View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] HammerJoe@gmail.com is offline
external usenet poster
 
Posts: 126
Default Need to prevent call Sub Worksheet_Activate() during macro.

I've run into a problem.

I have code that is supposed to be run everytime I activate the sheet,
which is located in the Private Sub Worksheet_Activate(),

Problem is that somewhere else in the code I have a routine to hide
all sheets except this particular one and Excel calls the Private Sub
Worksheet_Activate().
There are other instances as well that excel call for the sub when I
need it to to something on that sheet.
The problem is that Private Sub Worksheet_Activate() does some stuff
that I only want to be done when I select the sheet not when running
code.

Is there an easy way to make Excel ignore the sub unless I click on
the sheet tab to activate it?
Thanks