Hi Peo,
Thanks alot. I followed my nose and it is all working great.
Doing a great job, really appreciate it.
Sue

"Peo Sjoblom" wrote:

Right click the sheet in the VBE and select properties, click the protection
tab (rest should be self explanatory)
Won't help against someone that is determined enough to Google on how to
crack the protection but probably for the
average user

--
Regards,

Peo Sjoblom

(No private emails please)


"Sue" wrote in message
...
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