Macros - Hiding actions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
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?
 
You must log in or register to reply here.

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

Macro to hide sheets based upon cell value 3
running macro in entire workbook 7
Excel Monthly Spread sheet. 12
Macro to hide worksheet based upon text in the name 5
Action after save 3
Macro Execution, Part Duo 1
Excell 2000 macro will not open file! 1
diable macro if a certain sheet is active 3

Back
Top