run time error 1004

J

jimbob

I run some spreadsheets with macros (written by another party). No
everytime I open one and click on the "toggle" button I get th
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 uninstalle
Microsoft Office 97 and then reinstalled, but still get the sam
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
 
O

Otto Moehrbach

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
 
Top