I run some spreadsheets with macros (written by another party). Now
everytime I open one and click on the "toggle" button I get the
follwing error.....

"run time error 1004
unable to set the hidden property of the range class"

I know nothing about macros or VBA so I'm stumped. I uninstalled
Microsoft Office 97 and then reinstalled, but still get the same
problem. I also got another copy of the SS and it does the same thing,
so I am thinking it is something in the registry or outside of Excel.
Any ideas?


--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=568614

It's probably something to do with your data. When you get the error, it
will be shown to you in a box. At the bottom of that box is a button
labeled "Debug". Click on that button. That takes you to the VBA editor,
or VBE, and highlights the offending line of code. Copy that line of code
and post it in this newsgroup in this same thread. Also post the entire
macro in which that line appears. Also include an explanation of what you
think clicking on the "toggle" button is supposed to accomplish. HTH Otto
"jimbob" wrote in
message ...

I run some spreadsheets with macros (written by another party). Now
everytime I open one and click on the "toggle" button I get the
follwing error.....

"run time error 1004
unable to set the hidden property of the range class"

I know nothing about macros or VBA so I'm stumped. I uninstalled
Microsoft Office 97 and then reinstalled, but still get the same
problem. I also got another copy of the SS and it does the same thing,
so I am thinking it is something in the registry or outside of Excel.
Any ideas?


--
jimbob
------------------------------------------------------------------------
jimbob's Profile:
http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=568614