run time error 1004

  • Thread starter Thread starter jimbob
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-time error '1004' 5
Run-time Error '1004' 1
Run time error 1004 in loop 4
Ignore macro run time error 4
Run-time error '1004' 8
Run-time error '1004': AutoFill method of Range class failed 2
"Run-time error '1004' 5
PasteSpecial Error 1004? 3

Back
Top