Thread: password protect macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AidanH AidanH is offline
external usenet poster
  
Posts: 4
Default password protect macro
should work fine - see

ActiveSheet.Protect Password = "FRED"
ActiveSheet.Unprotect Password = "FRED"


which (rather pointlessly) protects and unprotects a sheet without
doing anything else

Reply With QuoteReply With Quote