Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
event before open
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
event before open
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 -- Howard31 "Jay" wrote: 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
event before open
Tks for the return, will do that !!! J -- Cheers! "Howard31" wrote: 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 -- Howard31 "Jay" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Event | Excel Discussion (Misc queries) | |||
Open Event not working | Excel Programming | |||
Open Event | Excel Programming | |||
user form-on open event? keydown event? | Excel Programming | |||
Open event | Excel Programming |