Hi dominicb,
Sue again.
Have got the password sorted so no problems there thanks to you. However, I
am concerned that if someone right clicks on the worksheet tab and clicks
view code, that they will see the password. How do I hide it so it can't be
seen?

"dominicb" wrote:


Good morning Sue

Problem 1:
Use of the password property as shown below will solve that problem.
ActiveSheet.Unprotect Password:="pass"

Problem 2:
Renaming your macro auto_open will cause it to run automatically on the
file being opened.

If you prefer you can set it up as an event procedure - in this case
rename your macro Private Sub Workbook_Open() and move it from the
modules part of the VBE to ThisWorkbook.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=482553