error?: unhide upon edit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vizualman - 24 Feb 2007 08:30 GMT

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.

Reply to this Message

E-Coder - 27 Feb 2007 14:12 GMT

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

Do you have any macros running in the background?

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

Reply to this Message

vizualman - 28 Feb 2007 07:06 GMT

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

Any ideas?

> Is this happening on new workbooks? Or just ones created in a prior version?
>
[quoted text clipped - 3 lines]
> > rows become unhidden. Not sure if this is an app error or a feature of 2003.
> > Never encounted this in 2000.

Reply to this Message

E-Coder - 28 Feb 2007 13:53 GMT

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.

> This appears to be happening in prior version workbooks, and yes they do have
> macros running in the BG.
[quoted text clipped - 8 lines]
> > > rows become unhidden. Not sure if this is an app error or a feature of 2003.
> > > Never encounted this in 2000.

Reply to this Message

vizualman - 28 Feb 2007 15:29 GMT

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!

> 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
[quoted text clipped - 12 lines]
> > > > rows become unhidden. Not sure if this is an app error or a feature of 2003.
> > > > Never encounted this in 2000.

Reply to this Message

E-Coder - 28 Feb 2007 15:35 GMT

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?

> 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
[quoted text clipped - 18 lines]
> > > > > rows become unhidden. Not sure if this is an app error or a feature of 2003.
> > > > > Never encounted this in 2000.

Reply to this Message