excel 2000 VBA Password

  • Thread starter Thread starter vinimall
  • Start date Start date
V

vinimall

Can anyone advise me on how to secure a excel 2000 workbook by using
VBA? I want the user to have a "user name" and "password" which they
have to enter when opening the excel workbook

many thanks
 
HI vinimall,

You don't need to use VBA for that; when you're saving the workbook, you can
choose General Options from the Tools dropdown in the Save dialog box. This
will allow you to put a password on the workbook, and the security of this
option is much higher than what you could do with VBA.

--
Regards,

Jake Marx
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
Back
Top