Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Locking user access while macro runs in Excel
- Thread starter Roosters
- Start date
JVFriederick
IS-IT--Management
See if this works for you.
AT THE START OF MACRO:
Application.Cursor = xlWait ' Smoothes out the macro execution
CaptionSave = ActiveWorkbook.Windows(1).Caption ' Saves heading at top of screen
ActiveWorkbook.Windows(1).Caption = "Doin my thing, please wait . . . ."
AT THE END OF MACRO:
ActiveWorkbook.Windows(1).Caption = CaptionSave ' Put caption back
Application.Cursor = xlDefault
AT THE START OF MACRO:
Application.Cursor = xlWait ' Smoothes out the macro execution
CaptionSave = ActiveWorkbook.Windows(1).Caption ' Saves heading at top of screen
ActiveWorkbook.Windows(1).Caption = "Doin my thing, please wait . . . ."
AT THE END OF MACRO:
ActiveWorkbook.Windows(1).Caption = CaptionSave ' Put caption back
Application.Cursor = xlDefault
- Status