Thread: How to protect a sheet with pasword
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default How to protect a sheet with pasword
Try something like

Sub ProtectSheet()
ActiveSheet.Protect password:="galileo"
End Sub


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"filo666" wrote in message
...
Hi, I want to make a macro, ehn the user press a button, the
sheet is
automatically protected with the pasword:= "galileo"
TIA


Reply With QuoteReply With Quote