Thread: Protecting worksheet.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] benmcclave@gmail.com is offline
external usenet poster
  
Posts: 29
Default Protecting worksheet.
Rich,

You are missing a colon after Password. This line worked for me:

ActiveSheet.Protect Password:="guru11"

-Ben
Reply With QuoteReply With Quote