Protected workbooks

[Turtleman10]

Is there a way to referance a cell in a protected workbook with a macro or is it just not possible?

 

[SkipVought]

hi,

A protected workbook probably means that you need a password to get in.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Turtleman10]

I can open it up as read only I just didnt know if I could just referance a cell not make a change to it just referance it without a password. When i try I get an error so Im guessing you are correct I need a password to do it. Thanks for your help.

 

[SkipVought]

How do you open it as read only?

How are you referencing the cell?

Please post your code.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}