View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
r wilcox r wilcox is offline
external usenet poster
 
Posts: 14
Default Password Protect Worksheet

If I enter the following code, my sheet is password protected

ActiveSheet.Protect ("password")

If I expand on it with either of the following, I get a code error.

ActiveSheet.Protect ("password") DrawingObjects:=False
ActiveSheet.Protect DrawingObjects:=False ("password")

What is the correct format?

Thanks.