Intervening in a "hidden" spreadsheet process.

  • Thread starter Thread starter John Baker
  • Start date Start date
J

John Baker

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
 
Look in Excel VBA help at the EnableCancelKey property/method of the
Application.Object
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub Autoexec () will not start the Macros running! 0
How do I find what is in a spreadsheet 4
Automated Process that Updates all Spreadsheets in a Folder 1
Lookups - how to obtain data from a master spreadsheet into another 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Sub Workbook_Open not called when opening spreadsheet 6
How to launch Macro/Code form command line 2
Macro works but also runs original spreadsheet 5

Back
Top