error?: unhide upon edit

V

vizualman

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.
 
E

E-Coder

Is this happening on new workbooks? Or just ones created in a prior version?

Do you have any macros running in the background?
 
V

vizualman

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

Any ideas?
 
E

E-Coder

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.
 
V

vizualman

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!
 
E

E-Coder

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't save my Office documents (after computer rebuild and reauthorization) 0
Excel 2003 on Vista: Some rows disappear in worksheets 1
Help with conditionally unhiding columns 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Merging from an Excel file with graphics 1
Unable to unhide rows 1
Hiding and unhiding rows with if statement macro 1
Automatic Hide/Unhide Programming 1

Top