Thread: Password protecting sheets through VBA
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Password protecting sheets through VBA
Yes it is available

ActiveSheet.Protect Password:="Ron"

ActiveSheet.Unprotect Password:="Ron"


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Eithne R" wrote in message ...
I want to password protect a spreadsheet / sheets but need to be able to
unprotect them to manipulate them via a macro. Is this possible? The
password option does not appear to be available in the protect method. Cheers


Reply With QuoteReply With Quote