View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carlee Carlee is offline
external usenet poster
 
Posts: 155
Default Password Protect a single sheet using VBA

Hello All,
Question:
How can i programmatically password protect a single password.

I want the user to be presented with an input box where they are asked to
enter a password. If the password entered is correct, then go to Sheet 1,
else display a message saying 'Incorrect Password' and return the user to the
Main Menu, preventing the user from accessing Sheet 1.

Suggestions?
--
Carlee