Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to insert a breakpoint and run the Workbook_Open event ??
Rather an elementary question, but I am trying to step through my
Workbook_Open event and would like to insert a breakpoint in the code and then step through it. But how can I do that when the breakpoint vanishes when I first close the workbook ? ........ Anno domini again... Charles |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to insert a breakpoint and run the Workbook_Open event ??
Put a Stop in the code
statement 1 Stop statement 2 -- HTH RP (remove nothere from the email address if mailing direct) "Charles Jordan" wrote in message om... Rather an elementary question, but I am trying to step through my Workbook_Open event and would like to insert a breakpoint in the code and then step through it. But how can I do that when the breakpoint vanishes when I first close the workbook ? ....... Anno domini again... Charles |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to insert a breakpoint and run the Workbook_Open event ??
Locate the cursor on the line of code where you want execution to stop &
press F9. (Another F9 will remove the stop). Then Press F8 to contiue one line at a time. "Charles Jordan" wrote: Rather an elementary question, but I am trying to step through my Workbook_Open event and would like to insert a breakpoint in the code and then step through it. But how can I do that when the breakpoint vanishes when I first close the workbook ? ........ Anno domini again... Charles |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to insert a breakpoint and run the Workbook_Open event ??
You can put your cursor in the Workbook_Open procedure, and start it executing by
pressing F8 to step through or F5 to run through. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Charles Jordan wrote: Rather an elementary question, but I am trying to step through my Workbook_Open event and would like to insert a breakpoint in the code and then step through it. But how can I do that when the breakpoint vanishes when I first close the workbook ? ........ Anno domini again... Charles |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to insert a breakpoint and run the Workbook_Open event ??
Jon Peltier wrote in message ...
You can put your cursor in the Workbook_Open procedure, and start it executing by pressing F8 to step through or F5 to run through. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Charles Jordan wrote: Rather an elementary question, but I am trying to step through my Workbook_Open event and would like to insert a breakpoint in the code and then step through it. But how can I do that when the breakpoint vanishes when I first close the workbook ? ........ Anno domini again... Charles Bob - thank you so much. I wasn't aware of the word "Stop" being available in VBA - must have arrived since XL 95 where I was born. Not often highlighted either in the books - try looking at (John Walkenbach's "Power Programming in VBA" - my bible )where it seems not to appear, in the index anyway... |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to insert a breakpoint and run the Workbook_Open event ??
Jon Peltier wrote in message ...
You can put your cursor in the Workbook_Open procedure, and start it executing by pressing F8 to step through or F5 to run through. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Charles Jordan wrote: Rather an elementary question, but I am trying to step through my Workbook_Open event and would like to insert a breakpoint in the code and then step through it. But how can I do that when the breakpoint vanishes when I first close the workbook ? ........ Anno domini again... Charles Jon - thank you - I knew about F8 and F5 but stupidly didn't try stepping thru WorkBook_open . Discovered it for myself just after posting to the NG, so much embarrassment. Bob's contribution is most valuable actually too. Tks Charles |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_Open() Event | Excel Discussion (Misc queries) | |||
Workbook_open Event | Excel Programming | |||
Workbook_Open Event | Excel Programming | |||
WorkBook_Open Event | Excel Programming | |||
OnTime event not firing in Workbook_Open event procedure | Excel Programming |