View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_4_] Jim Thomlinson[_4_] is offline
external usenet poster
 
Posts: 1,119
Default Macro sheet by sheet error

Without seeing any code it is impossible to say... I assume that you are
using on change event procedures. Are the event procedures in the sheet or in
thisworkbook?
--
HTH...

Jim Thomlinson


"Daniel R. Young" wrote:

I have a macro where when a cell on sheet 1 is selected to "NO" certin rows
on the next sheet (2) will hide.

When I go to sheet 2 and enter text in cell 'A1' the sheet go through all
the macro's on that page (there are cells that will hide some rows on sheet 2
when some cell are selected as "NO") and the rows that were once hidden now
appear.

Why would this happen?

Thank you,

Dan