Password help needed

  • Thread starter Thread starter JimWeb
  • Start date Start date
J

JimWeb

I am using Excel 2000 for an IT project. I need to create some sort o
password protection for a page of values (lookup data that is used b
the main worksheet) however I have found this difficult. Can I create
user form in visual basic, that includes a textbox and ok and cance
buttons to do this. I wanted the system to allow the correct users t
type in the correct password and be able to access the worksheet.

I know I could use sheet protection but I think this is unnecessary, a
the user would have to protect and unprotect the sheet after change
have been made. Is sheet protection my only option? Or can I use visua
basic to create a more automated system?

Any help would be appreciate
 
You will have to use usual sheet protection, but you can include a macr
to accept a password and unprotect. If you put code to protect th
sheet(s) in the Workbook_Close event (and Save) the user will not nee
to do this
 
Back
Top