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

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

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

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

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

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.