Ignore all Worksheet_Activate events

Topic

New Reply

Hi,

I have one macro, that when running, I would like all Worksheet_Activate events to be ignored. Is this possible?

Thanks

Reply | Quote

Replies

You can turn off ALL event handling with the line

Application.EnableEvents = False

Don’t forget to turn it on again at the end using

Application.EnableEvents = True

(it’s not reset automatically!)

Reply | Quote

Thanks Hans.

Reply | Quote

Depending on what the code is, you might also simply be able to stop activating the sheets in the first place!

Reply | Quote

Over time as my vba knowledge had increased, my use of select has decreased a lot. However, I must admit that I am still not fully sure where select is necessary and where it is not. It is definately an area that I should brush up on!

Reply | Quote

Your best bet is to assume you don’t need to select…

I would be hard pressed to find an instance where SELECTing is required.

Steve

Reply | Quote

Freeze panes and checking some relative conditional formats are the only ones I can think of offhand.

Reply | Quote