Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a WorkSheet be proteced from deletion
Is there a way to prevent a user from deleting a given WorkSheet? Also, is
there a way to prevent the user from "UnHiding" a WorkSheet?? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a WorkSheet be proteced from deletion
Sheets hidden manually or hidden with a macro can still be unhidden, password
protecting the hidden sheet might make this harder, but still. Now a macro that hides a worksheet using the xlVeryHidden flag cannot be unhidden manually in any way. It can only be unhidden with another macro. sub HideSheet1() Sheets("Sheet1").Visible = xlVeryHidden end sub -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Mike" wrote: Is there a way to prevent a user from deleting a given WorkSheet? Also, is there a way to prevent the user from "UnHiding" a WorkSheet?? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a WorkSheet be proteced from deletion
Mike;313562 Wrote: Is there a way to prevent a user from deleting a given WorkSheet? Also, is there a way to prevent the user from "UnHiding" a WorkSheet?? ThanksProtecting the workbook structure should prevent sheet deletion. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=87654 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a WorkSheet be proteced from deletion
Thanks JB. Works great. Just what I wanted.
"JBeaucaire" wrote in message ... Sheets hidden manually or hidden with a macro can still be unhidden, password protecting the hidden sheet might make this harder, but still. Now a macro that hides a worksheet using the xlVeryHidden flag cannot be unhidden manually in any way. It can only be unhidden with another macro. sub HideSheet1() Sheets("Sheet1").Visible = xlVeryHidden end sub -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Mike" wrote: Is there a way to prevent a user from deleting a given WorkSheet? Also, is there a way to prevent the user from "UnHiding" a WorkSheet?? Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a WorkSheet be proteced from deletion
Thanks Simon. I kept thinking Protect Sheet rather than Protect WorkBook.
Works great. "Simon Lloyd" wrote in message ... Mike;313562 Wrote: Is there a way to prevent a user from deleting a given WorkSheet? Also, is there a way to prevent the user from "UnHiding" a WorkSheet?? ThanksProtecting the workbook structure should prevent sheet deletion. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=87654 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can a WorkSheet be proteced from deletion
On Sat, 18 Apr 2009 20:38:11 -0700, "Mike" wrote:
Is there a way to prevent a user from deleting a given WorkSheet? Also, is there a way to prevent the user from "UnHiding" a WorkSheet?? Thanks Right click on the worksheet name tab and select protect. Then use a password that your user does not know. To prevent unhiding, protect the entire workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying data from a proteced worksheet | Excel Discussion (Misc queries) | |||
protect worksheet but allow row deletion | Excel Worksheet Functions | |||
deter worksheet deletion | Excel Programming | |||
PROTECED SHEETS | Excel Discussion (Misc queries) | |||
resequence worksheet index after deletion of worksheet | Excel Programming |