Visible Property

S

Shawn

I am running Excel 2003 and have a VBA code I have been using for years
without issue. I ran it today and got a Run Time Error 1004: Unable to set
the Visible Property of the Worksheet Class. When I hit the debugger button
it takes me to the line of code that tries to turn on and off (ture and
false) the visible property.

The VBA is in one excel workbook and when I click a button it runs in
another open excel workbook.

What has changed?
 
M

Mike H

Hi,

I hate it when you hit the debugger button and it does that:)

Maybe someone has protected the workbook structure which would stop your
code hiding the sheet.

Mike
 
J

JLGWhiz

Check your object value. If it cannot set the visible property, maybe the
object value is not what you think it is.
 

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

Preventing "Protect Workbook" 2
Sheets visible toggle code 3
Help on Visible Property 7
VBA visible property 1
Unable to set the Visible property of the Worksheet class 1
Why do charts disappear? 2
Checkbox problem 5
Set Pivot-Table Visible Items 1

Top