Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form.Show Problem in Excel 2003
Hi,
I have a form named "Main" which occasionally err's out on the Main.Show line when ran on Excel 2003, if Continue is clicked the form will appear but other unexplainable problems then start appearing in other modules when the user selects options from the form Until recently the code below has worked fine in Excel 2003 (11.5612.5606), I do not know if there has been any office updates made to the PC's that use Excel 2003 which has caused this to err on the Main.Show line (See code snippet below) I myself use Excel 2000 (9.0.4402 SR-1) as do a lot of other users and the code works fine Code below is in a Auto_Open module With Main .dFolder = "\\Kels-dsk-001\Projected Inventory\" .wFolder = "\\Kels-dsk-001\Shared\Raymond Allan\" .NewFile.Value = ThisWorkbook.Name .MultiPage1.Value = 0 .cb6 = False .EndOfQtr = Format(GetLastQuarterEnd, "dd-mmm-yy") .fMonth = Month(Now()) End With Windows(Main.NewFile).Activate ' Hide the workbook during the running of the program Windows(Main.NewFile).Visible = False Main.Show Any help or advice on this greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003? | Excel Discussion (Misc queries) | |||
How do I get 2003 Macros and Toolbar Buttons form Excel 2003 to 20 | New Users to Excel | |||
Form.Show problem | Excel Programming | |||
How to show to a form in excel vba? | Excel Programming | |||
Help! Animated gif-image in form does not show animation when form loaded | Excel Programming |