macroB to not activate when macroA is executing

[jw01]

hello

i have the following macro that filters data when i press a button. the macro goes into "master" sheet, however the macro on the master sheet is "Private Sub Worksheet_Activate()" so each time you jump to that sheet, it runs that macro.

is there a way when i run my macro (see below), it disables the macro in the master sheet?

Please Login or Register  to view this content.

any help would be truly appreciated.

[Norie]

You could rewrite the code so it doesn't activate the sheet.

Alternatively you can disable events at the start.

Please Login or Register  to view this content.

Remember to re-enable events at the end.

Please Login or Register  to view this content.

[jw01]

hello

should i just place this at the beginning and at the end..or a particular spots?

thx u sir.

[Norie]

You disable events at the start and enable them at the end.

PS I edited my post - got the code for enabling slightly wrong.

[jw01]

awesome that works great...thx u sir!