View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scrabtree[_2_] scrabtree[_2_] is offline
external usenet poster
 
Posts: 47
Default password protect

I have a sheet that is password protected and is protected
against comments and scenerios but not objects. I wrote a
macro that would unprotect the sheet, alter a few things,
then reprotect it.

Here is the code: Sheets("Time").Unprotect
Password:="TimeFlash" ... then later Sheets
("Time").Protect Password:="TimeFlash"

However, by default, this protects it against comments,
scenerios and objects. I don't want it to protect against
objects. What is the better code?