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

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

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

If you get warning when you open the workbook, just say No to it, and then
follow Bernie's suggestion. If you don't then make sure security is at
MEDIUM (ToolsMacroSecurity...), check Medium on the Security Level tab.
Save and close it, open it again, if you still get no warning, there are no
macros.
--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"kthomas" wrote in message
...
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

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

Security level is already at "high" and I don't get any warnings when I open
it. I don't know what enabling macros means... is that only if I get a
warning? What next??
--
kthomas


"Igneshwara reddy" wrote:

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

If you are set to "High" you will get no warning and macros will be disabled by
Excel.

If set to "medium" you will get a warning and the choice to enable or disable
macros.

If set to "low" there will be no warning and macros will be enabled.


Gord Dibben MS Excel MVP

On Fri, 2 Mar 2007 10:26:05 -0800, kthomas
wrote:

Security level is already at "high" and I don't get any warnings when I open
it. I don't know what enabling macros means... is that only if I get a
warning? What next??

If your security level is at High (or Very High) then you won't get any
warnings about code being in the workbook, it will simply disable them UNLESS
they happen to be digitally signed by a trusted source. Then they may run
without alerting you.

I'd try this: go back into Macro Security and set the level to MEDIUM.
Close Excel (must be done for Excel to see the new security setting) and
reopen it. Load your workbook and then see if an alert comes up telling you
that the workbook has macros and asking you if it should permit them to run
(Enable) or not (disable). If this warning comes up, choose the [Disabled]
option and see how it behaves.

If it does not come up, most likely you do not have any macro code in the
workbook. Then we have to look elsewhere for the cause. It's pretty tough
to do anything like truly hide an entire row without code. I'm thinking that
conditional formatting could make things almost invisible, so please define
"hidden" - do you mean that you cannot even see the row numbers at the left
at all or that you can see the row numbers, but not the information in them?
Also you say you have to unhide each one individually and cannot select all
rows by clicking on a column letter and using unhide? What about if you
click on on a column letter and then choose [Format] then [Row] then Height
and set the row height to some non-zero value - say about 12 or 13? 12.75 is
default height for rows with 10 point font in them.

"kthomas" wrote:

Security level is already at "high" and I don't get any warnings when I open
it. I don't know what enabling macros means... is that only if I get a
warning? What next??
--
kthomas


"Igneshwara reddy" wrote:

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