Hi Thomas,

It is eary to set Macors level High.

Go to Tools - Options - Security - Macro security and then select High as
required.

"kthomas" wrote:

Bernie,
Thanks for replying! Please forgive my ignorance, but could you tell me how
to set the security level to high? I'm just a beginner! THanks!
--
kthomas


"Bernie Deitrick" wrote:

k,

It sounds like there is event code doing things in the background.

Try setting your macro security level to high, then open the workbook, and
DON'T enable macros. Unhide the rows, and see if the workbook behaves.

If it does behave when macros are disabled, right-click on each sheet tab,
select "View Code" and either comment out or delete any code that appears.
Note that you may lose functionality - you could post the code here to get
help figuring out what it is doing.

HTH,
Bernie
MS Excel MVP


"kthomas" wrote in message
...
I have a spreadsheet I use every day at work. A few weeks ago it started
hiding all the new data entries I made. I never knowingly changed any
properties and am convinced this spreadsheet is now possessed. I can
unhide
each row individually but it won't stay unhidden, even if I save the whole
thing under another name. Nor can I unhide them all at once by
highlighting
the whole spreadsheet and right clicking on "unhide". I also tried
cutting
and pasting into a new spreadsheet. Usually it unhides anything hidden,
but
that didn't work either. It's becoming a really serious problem for me at
work and no one knows what to do. Please help!!
--
kthomas