Lost Formatting

**Bardess** · 03-31-2009, 01:27 PM

I hope i'm able to appropriately explain my problem.

I am creating a simple 'Holiday Request' form. I have managed to insert a drop down calendar, and am happy with the results.

However, each time i close the document, and return to it the next day, i find that the formatting for the calendar combo box changes. If i'm to use this form for easy employee use, it must hold it's formatting.

Anyone able to help? (This is one of 2 or 3 issues i'm trying to iron out, before i can roll out the new electronic form. I really appreciate any assistance!)

**mubashir aziz** · 04-01-2009, 01:27 AM

can you attach the file ???

**Bardess** · 04-01-2009, 09:42 AM

Sure, i'll attach a dummy file to show you what's happening.

Simple combo date boxes, formatted to fit the cell. When file is closed, and repoened, combo boxes lose their formatting.

**mubashir aziz** · 04-02-2009, 05:19 AM

I have just added this VBA code in your workbook_open code and now its working

Private Sub Workbook_Open()

Application.ScreenUpdating = False

ActiveWindow.ScrollRow = 2
ActiveWindow.ScrollRow = 1

Application.ScreenUpdating = true

End Sub