View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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