Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visible Property
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? -- Thanks Shawn |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visible Property
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 "Shawn" wrote: 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? -- Thanks Shawn |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visible Property
Check your object value. If it cannot set the visible property, maybe the
object value is not what you think it is. "Shawn" wrote: 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? -- Thanks Shawn |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visible Property
Maybe you were trying to hide the only visible sheet in the workbook.
Shawn wrote: 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? -- Thanks Shawn -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help on Visible Property | Excel Programming | |||
VBA visible property | Excel Programming | |||
Visible property on Worksheets | Excel Programming | |||
Visible Property | Excel Programming | |||
.Visible Property | Excel Programming |