Run Workbook_Open only if called

  • Thread starter Thread starter Jarek
  • Start date Start date
J

Jarek

Hello,
I have my procedure in Workbook_Open(), which I want to run only if th
workbook was opened 'remotely' (via VBA or Task Scheduler). Is thi
possible?

Thanks,
Jare
 
This is an untested suggestion, but look at the help on

Application.UserControl

it describes the situation for the application, but I think in the instances
you describe, it should be reliable. If you are writing the code that would
open it remotely, then you might create some condition it could check and
perhaps use a combination of that and the UserControl property.
 
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

automatically trying to run a macro at a certain time 0
automatically trying to run a macro at a certain time 1
Separating Workbooks 4
workbook_open() sub does not work 2
Unable to change ActiveSheet within Workbook_Open 2
Can't delete sheets 8
Private Sub Workbook_Open() 1
Workbook_open not running and Phantom Projects 6

Back
Top