Printable View
Does anyone know how to hide the selected cell (or active cell) while running a macro or vba application in Excel?
I just want the macro to run through a range of cells, do some formatting, but not show the box around each cell as it is being formatted.
Thanks
Steve
Well!
You can do one of three things.
You can use the following to block off the user from seeing. The code will be run in the back ground.
application.ScreenUpdating = False
Once you want to see the processing again, just change it to true.
Another alternative is hiding that column or row with the visible property.
Last, you can drop a label control in and move it over on top as it process.
If it was me, I would use the SCREENUPDATING property.
Nitro - thanks for the help. The application.screenupdating tip did the trick. Your quick response was very helpful - I was in a vba class, stumped the instructor and her vb specialist with the question, and was then able to tell them how to do it...
Thanks again
Steve
You welcome!
One more thing Steve. If you want to block off incoming key inputs and mouse (except input to dialog boxes that are displayed by your code) while the marco is running, you can also use
Application.interactive = false
If you do this, even if the user stand on the keyboard or use the mouse as a lasso, no input will be allowed.
Keep in mind to turn it back on before the macro ends.