Making macro functions invisible?

[Dan Winterton]

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

 

[Harald Staff]

Application.Screenupdating = False
and True at the end.

HTH. Best wishes Harald

 

[Niek Otten]

Hi Dan,

Application.Screenupdating = False

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Norman Jones]

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.

 

[Guest]

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...