event before open

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

good morning everyone, Thanks for all your prior answers, I have learned a
lot. Anyway, I have a rather large workbook that upon opening will take about
a minute to update. I want to set up a message box that will open and tell
the user not to update before Excel asks the user to update or don't update.
thanks for your assistance. J
Cheers!
 
Hi Jay

If what you mean by a long time to update is because of a procedure the
workbook is executing upon oppening, then you should create a userform with a
message that shows that the workbook is updating, in open event put the
following code in the first line:

UserForm1.Label1.Caption = "The workbook is now updating"
UserForm1.Show vbModeless

In the last line put the code:

UserForm1.Label1.Caption = "Updating complete"
Userform1.Show
 

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

open message box before the update or dont update message box open 2
Addin not allowing thisworkbook.save in before save event 3
Manual calculation to Automatic on close - BUT without recalculati 1
Update Links, Scheduled Tasks and UDFs 2
Worksheet appears briefly before UserForm opens 4
Using the OnTimer event to lock out users between specific time window. 12
before close event 5
MACRO HELP 2

Back
Top