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