error?: unhide upon edit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Just started using Excel 2003. Upon editing a cell, all hidden columns or
rows become unhidden. Not sure if this is an app error or a feature of 2003.
Never encounted this in 2000.
 
Is this happening on new workbooks? Or just ones created in a prior version?

Do you have any macros running in the background?
 
This appears to be happening in prior version workbooks, and yes they do have
macros running in the BG.

Any ideas?
 
I would suggest checking the code because it sounds like an event at the
worksheet level is being fired and causing this behavior. Check to see if
there are any events that hide columns and rows.
 
Thanks for the suggestion, however, I'm not a programmer and wouldn't know
where to look. Could you point me in the right direction or is totally out
of my league as I suspect?

Thanks!
 
No problem. What kind of macro is running in the background? Something
similar to an addin that Adobe PDF Maker puts in there or another program? Or
a Macro that someone you work with placed there?
 
Back
Top