View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robin1979 Robin1979 is offline
external usenet poster
 
Posts: 5
Default Password on Command Button

Hi

I have a very simple Command Button that is used for a user to change
worksheet however I would like to password protect this so that only certain
users can change into this sheet is anyone able to advise how to complete
this?

Current simple code is as follows:

Private Sub CommandButton1_Click()
Sheets("Sheet2").Select
End Sub

Thanks
Robin