| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable a worksheet so user cannot mess with
Goodday All I would like to know if it is possible to disable a sheet in a workboo using VBA so that a user is not able to tamper with it? Kind Regard -- popp ----------------------------------------------------------------------- poppy's Profile: http://www.excelforum.com/member.php...fo&userid=1145 View this thread: http://www.excelforum.com/showthread.php?threadid=31472 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow user to disable automatic hyperlink generation in Excel. | Excel Discussion (Misc queries) | |||
| trying to add a complicated mess to my worksheet... :) | Excel Worksheet Functions | |||
| I need to disable to X on a user form | Excel Discussion (Misc queries) | |||
| don't let the user disable macro's in Excel | Excel Programming | |||
| How to disable hide/unhise command by user? | Excel Programming | |||
Linear Mode
