View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Bob
 
Posts: n/a
Default Stop renaming or moving sheet tabs

I have a similar issue.
I can't protect the workbook because I have macros that hide and unhide
sheets.
I get a runtime 1004 error:
'unable to set the visible property of the worksheet class'

"Dave Peterson" wrote:

I don't think you protected the workbook correctly.

I'd try it once more.



sparx wrote:

Have tried and I can still insert, copy and move worksheets!.

--
sparx
------------------------------------------------------------------------
sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787
View this thread: http://www.excelforum.com/showthread...hreadid=542084


--

Dave Peterson