Macros - Hiding actions

J

JS

I have a spread sheet that contains several macros. Is it possible to hide the executions of the macros from the user and display a dialog box when the executions are complete?
 
C

Chip Pearson

JS,

Try something like

Application.ScreenUpdating = False
' your code here
Application.ScreenUpdating = True
MsgBox "All Done!"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




JS said:
I have a spread sheet that contains several macros. Is it
Click to expand...
possible to hide the executions of the macros from the user and
display a dialog box when the executions are complete?
 
J

Jason Morin

Sub YourMacro()

Msgbox "Please Wait..."
Application.ScreenUpdating = False
<<<your macro here>>>
Application.ScreenUpdating = True

End Sub

HTH
Jason
Atlanta, GA
-----Original Message-----
I have a spread sheet that contains several macros. Is
Click to expand...
it possible to hide the executions of the macros from the
user and display a dialog box when the executions are
complete?
 
Top