View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
excel_googler excel_googler is offline
external usenet poster
 
Posts: 1
Default Disable a worksheet so user cannot mess with


Hi..

Press Alt + F11 to get in to Microsoft Visual Basic Window..

Select the sheet to be hidden from “Project” window

Select Properties windows and choose “2 – xlSheetVeryhidden” fro
Visible Properties.

Close the window

Note: Go to View option and select Project & Properties window, if i
does not appear by default.

Hope this will take care of your problem

--
excel_google
-----------------------------------------------------------------------
excel_googler's Profile: http://www.excelforum.com/member.php...fo&userid=1661
View this thread: http://www.excelforum.com/showthread.php?threadid=31472