Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Intervening in a "hidden" spreadsheet process.
HI:
I have a spreadsheet that I am triggering from MS Access (it does some editing that Access is not very good at doing). I want to start the sheet with an auto_open, and have the whole process happen (right up to closing the spreadsheet again) with no user intervention. My question is: I also want to be able to get into the spreadsheet to make changes etc, and am wondering if there is some way I can set a breakpoint or something that will trigger the macros stopping if I press some function key. Any advice would be appreciated. Thanks John Baker |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Intervening in a "hidden" spreadsheet process.
Look in Excel VBA help at the EnableCancelKey property/method of the
Application.Object -- Regards, Tom Ogilvy "John Baker" wrote in message ... HI: I have a spreadsheet that I am triggering from MS Access (it does some editing that Access is not very good at doing). I want to start the sheet with an auto_open, and have the whole process happen (right up to closing the spreadsheet again) with no user intervention. My question is: I also want to be able to get into the spreadsheet to make changes etc, and am wondering if there is some way I can set a breakpoint or something that will trigger the macros stopping if I press some function key. Any advice would be appreciated. Thanks John Baker |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Intervening in a "hidden" spreadsheet process.
Thanks
John "Tom Ogilvy" wrote: Look in Excel VBA help at the EnableCancelKey property/method of the Application.Object |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"System" Process eating CPU in Excel 2003 | Excel Discussion (Misc queries) | |||
When I type "13" the spreadsheet shows "14." Possibilities? | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Can the "Save" process be speeded up? | Excel Programming |