View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pswanie pswanie is offline
external usenet poster
 
Posts: 247
Default protect sheet with password

i got a macro to protect my sheet and then navigate me to another sheet.

i need this macro to protect the sheet with a password and then i need
another macro to unprotect the password protected sheet.

this is what im using now

Sub data()

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
Application.MoveAfterReturnDirection = xlToRight
Sheets("data").Select
Range("A111").Select
End Sub