application.screenupdating = false
application.screenupdating = true

Always make sure that you turn it back on at the end of the procedure. It is
also a good idea to include it in error handling code (if you have any).
Don't turn it on and off multiple times withing the same set of function
calls or the screen will flash when it is turned on.

Hope this helps...

"Dan Winterton" wrote:

I am using VBA to hide and unhide certainworksheets based
on a user's input in a combobox. what is the VB function
for turning off the screen so that the user doesn't see
flashes as these worksheets hide and unhide?

Any help is greatly appreciated.
Thanks,
Dan Winterton