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

Application.Screenupdating = False
and True at the end.

HTH. Best wishes Harald

"Dan Winterton" skrev i melding
...
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

Hi Dan,

Application.Screenupdating = False

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Dan Winterton" wrote in message
...
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

Hi Dan,

Application.ScreenUpdating = False

'Your Code

Application.ScreenUpddating = True

However, It is rarely necessary to make selections and making repeated sheet
selections will cause the flashing that you have observed.

---
Regards,
Norman



"Dan Winterton" wrote in message
...
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

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