| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Don't show the steps in a macro
I don't want the users to see all of the steps in my macro. Is there a way
to just have a status bar and a message when complete instead? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Don't show the steps in a macro
put
sub your_name application.screenupdating = false 'your code .. .. application.screenupdating = true msgbox "Report Complete" end sub -- Gary "LSkarbek" wrote in message ... I don't want the users to see all of the steps in my macro. Is there a way to just have a status bar and a message when complete instead? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Don't show the steps in a macro
Thanks! I'll give it a try.
"Gary Keramidas" wrote: put sub your_name application.screenupdating = false 'your code .. .. application.screenupdating = true msgbox "Report Complete" end sub -- Gary "LSkarbek" wrote in message ... I don't want the users to see all of the steps in my macro. Is there a way to just have a status bar and a message when complete instead? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you show steps of a calculation? | Excel Discussion (Misc queries) | |||
| cumprinc, not sure how to use it, someone please show me steps ple | Excel Worksheet Functions | |||
| how can we hide the steps of macro running | Excel Discussion (Misc queries) | |||
| Steps from Macro recorder for Pivot table will not run as a Macro | Excel Programming | |||
| Fill series macro with different steps | Excel Programming | |||
Hybrid Mode
