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]


vinimall wrote:
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/