Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open() Not executing
Miffed.
My spreadsheet which relies hevily on certain code being executed when the sheet is opened, but work open event is not executing. This morning it stopped working? Private Sub Workbook_Open() Application.ScreenUpdating = False MsgBox "Made it to wrokbook _open" Call InitialiseSheet Call Add_Custom_Menu Call Run_Filters Application.ScreenUpdating = True Range("a2").Select End Sub There is no enable event code either false or true in the workbook. Any ideas? Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open() Not executing
Dave,
Why don't you put some debug statements in the code and find out where it stops working? -- HTH RP (remove nothere from the email address if mailing direct) "Dave is Miffed" <Dave is wrote in message ... Miffed. My spreadsheet which relies hevily on certain code being executed when the sheet is opened, but work open event is not executing. This morning it stopped working? Private Sub Workbook_Open() Application.ScreenUpdating = False MsgBox "Made it to wrokbook _open" Call InitialiseSheet Call Add_Custom_Menu Call Run_Filters Application.ScreenUpdating = True Range("a2").Select End Sub There is no enable event code either false or true in the workbook. Any ideas? Dave |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open() Not executing
Not terribly familiar with debugs. I have been in contact with my help desk.
They can run the macro fine and get the msgbox when workbook is opened indicating that all the code is executed. Macros security settings are correct. we think we have a novell profile problem. I would appreciate debug tip however "Bob Phillips" wrote: Dave, Why don't you put some debug statements in the code and find out where it stops working? -- HTH RP (remove nothere from the email address if mailing direct) "Dave is Miffed" <Dave is wrote in message ... Miffed. My spreadsheet which relies hevily on certain code being executed when the sheet is opened, but work open event is not executing. This morning it stopped working? Private Sub Workbook_Open() Application.ScreenUpdating = False MsgBox "Made it to wrokbook _open" Call InitialiseSheet Call Add_Custom_Menu Call Run_Filters Application.ScreenUpdating = True Range("a2").Select End Sub There is no enable event code either false or true in the workbook. Any ideas? Dave |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open() Not executing
AT various points in the code add statement like
Debug.Print "Debug point 1" then 2, 3 etc. When the code runs, these will. be shown in the Immediate window in the VBE (use Ctrl-G in VBE to see this window). By following the debug statements, you can see which pieces of your code get executed and which do not. Typically, you would add a few general debug statements, and then when you identify where it stops, and some more, and drill down into the trouble spot. Another way is to use single-stepping. In this, you open up the Workbok_Open macro, put the cursor in that macro (anywhere in it), and menu DebugStep Into (or F8). Then just F8 through the code, and you will step into each line as it gets executed, and you can trace where it goes wrong. -- HTH RP (remove nothere from the email address if mailing direct) "Dave is Miffed" wrote in message ... Not terribly familiar with debugs. I have been in contact with my help desk. They can run the macro fine and get the msgbox when workbook is opened indicating that all the code is executed. Macros security settings are correct. we think we have a novell profile problem. I would appreciate debug tip however "Bob Phillips" wrote: Dave, Why don't you put some debug statements in the code and find out where it stops working? -- HTH RP (remove nothere from the email address if mailing direct) "Dave is Miffed" <Dave is wrote in message ... Miffed. My spreadsheet which relies hevily on certain code being executed when the sheet is opened, but work open event is not executing. This morning it stopped working? Private Sub Workbook_Open() Application.ScreenUpdating = False MsgBox "Made it to wrokbook _open" Call InitialiseSheet Call Add_Custom_Menu Call Run_Filters Application.ScreenUpdating = True Range("a2").Select End Sub There is no enable event code either false or true in the workbook. Any ideas? Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_Open () | Excel Discussion (Misc queries) | |||
Workbook_Open | Excel Programming | |||
workbook_open | Excel Programming | |||
Workbook_Open | Excel Programming | |||
Help with Workbook_Open | Excel Programming |