visible method of worksheet class failed error

B

bigjim

I am running exel 2003 and get a run-time error '1004 Visible method of
worksheet class failed. I am simply trying to go from one sheet that is
visible now <costsheet> to another sheet <Main> that is not visible now.
When I get to <main>, I then want to hide <costsheet> I have tried all the
tricks I know of to no avail and could use a little help. Here is my code:

ActiveWorkbook.Unprotect Password:="pw"
Dim Main As Worksheets

Worksheets("Main").Unprotect Password:="pw"


Worksheets("Main").Visible True <This is where it bogs down

Worksheets("Main").Range("d2").Select

Worksheets("costsheet").Visible False
Worksheets("Main").Protect Password:="pw"
ActiveWorkbook.Protect Password:="pw"


End Sub
 

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

Sheets visible toggle code 5
Protect each worksheet individually 4
Locking/Unlocking sheets using a range. 5
VBA visible property 1
Runtime error 1004: Select method of worksheet class failed 3
Run-time-error 1004 "ListIndex method of listbox class failed" 1
Activebook.Unprotect in macro giving errors (Pwd)#2 0
Help with VB code 2

Top