If you don't want them to have to enter a password, then don't use one.

Allowing the user to open the workbook just by clicking the enable macros button
doesn't seem too secure to me.



LAF wrote:

We are using Excel 2002. If I set a password to open the file, is there
code I can put in the Workbook_Open event to automatically open the file
when they Enable macros instead of having the user have to enter the pw.
We don't want to give the pw to the users.

--
LAF
------------------------------------------------------------------------
LAF's Profile: http://www.excelforum.com/member.php...fo&userid=9656
View this thread: http://www.excelforum.com/showthread...hreadid=482271

--

Dave Peterson