Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Elliott Jones   on Dec 19 In MS Office Category.

  
Question Answered By: Jawahir Burki   on Dec 19

First answer off the top of my head (and there are undoubtedly better ones -
heads and answers) is to use a userform instead of a messagebox and make it
non modal. If the UserForm button click sets a public variable and closes
itself, the main macro  can test that variable. (Don't forget to set it back
when the next instance comes up).

I wonder, however if you could run  the macro in the open  instance of excel  if
there is one so avoiding the readonly box  on reopening personal.xls. This
should happen if you tell the scheduler to open the file (.xls) rather than to
open excel and run the file. Not sure if this helps though.

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Procedure to abort automatic procedure? Or get search suggestion and latest updates.


Tagged: