Home |
Search |
Today's Posts |
#1
|
|||
|
|||
invisible macro commands?
What is the command to make the steps in a macro invisible to the user? That
is, when I press the button I would like to just see the final result and not the blinkety blinkety as each command is executed. Thx! Julie |
#2
|
|||
|
|||
invisible macro commands?
try
application.screenupdating=false your code application.screenupdating=true -- Don Guillett SalesAid Software "Julieeeee" wrote in message ... What is the command to make the steps in a macro invisible to the user? That is, when I press the button I would like to just see the final result and not the blinkety blinkety as each command is executed. Thx! Julie |
#3
|
|||
|
|||
invisible macro commands?
Hi there Julie,
Add a couple of lines to your code ... Sub YourMacroHere Application.ScreenUpdating = false '... your code here ... Application.Screenupdating = true End Sub HTH -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) "Julieeeee" wrote in message ... What is the command to make the steps in a macro invisible to the user? That is, when I press the button I would like to just see the final result and not the blinkety blinkety as each command is executed. Thx! Julie |
#4
|
|||
|
|||
invisible macro commands?
That does it. Thank you Don!
"Don Guillett" wrote: try application.screenupdating=false your code application.screenupdating=true -- Don Guillett SalesAid Software "Julieeeee" wrote in message ... What is the command to make the steps in a macro invisible to the user? That is, when I press the button I would like to just see the final result and not the blinkety blinkety as each command is executed. Thx! Julie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) |