Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003? Rob Gordon Excel Discussion (Misc queries) 1 December 2nd 08 09:34 PM
How do I get 2003 Macros and Toolbar Buttons form Excel 2003 to 20 Scott Sornberger New Users to Excel 2 March 19th 08 11:42 AM
Form.Show problem Glen Mettler[_4_] Excel Programming 2 August 9th 05 01:51 PM
How to show to a form in excel vba? Grd Excel Programming 2 July 19th 05 01:19 AM
Help! Animated gif-image in form does not show animation when form loaded JoCa Excel Programming 4 September 23rd 04 07:43 PM


All times are GMT +1. The time now is 04:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"