Help Needed with password protection

  • Thread starter Thread starter cgraham
  • Start date Start date
C

cgraham

Hello Everyone,

First of all I am new to these forums so I just wanted to say "hi" t
everyone:)

I am experiencing some problems with password protection. What I hav
are two separate workbooks. Workbook1 and Workbook2. Workbook2 has
cell in Sheet1 linked to Workbook1, however, Workbook1 requires
password to open it. The problem is that when I open Workbook2 and i
wants to update the "link" to Workbook1 it then prompts me for th
password for Workbook1 - is there any way around prompting for thi
password but still having one i.e. running some sort of macro in th
background upon opening Workbook2? Hopefully this is not a stupi
question;)

Thanks for you help.

Cheers,
C
 
I hope you are not relying on a pass word to do anything more than stop a
casual browser. it is possible to download a password cracker which will
tell you (in a few seconds) the password for an Excel or word file what a pp

Regards.

Bill Ridgeway
Computer Solutions
 
cgraham said:
Hello Everyone,

First of all I am new to these forums so I just wanted to say "hi" to
everyone:)

I am experiencing some problems with password protection. What I have
are two separate workbooks. Workbook1 and Workbook2. Workbook2 has a
cell in Sheet1 linked to Workbook1, however, Workbook1 requires a
password to open it. The problem is that when I open Workbook2 and it
wants to update the "link" to Workbook1 it then prompts me for the
password for Workbook1 - is there any way around prompting for this
password but still having one i.e. running some sort of macro in the
background upon opening Workbook2? Hopefully this is not a stupid
question;)

Thanks for you help.

Cheers,
CG
Click to expand...

Yes, put subprocedure in the module for the corresponding sheet in the VBA Project:

Private Sub Worksheet_Calculate()

Me.Unprotect ("yourpassword")

End Sub

I found this on http://www.intertek.org.uk
 
Back
Top