Viewing Cells of a protected workbook through another workbook

[elaiwa]

Hello,

Can anybody help me with the issue in the subject?

Is there any way to view some cells in a password protected workbook without being prompt to this password...

I have a workbook(A) that conatains some cells that are linked to some other cells that are located in a password protected workbook(B),

Whenever I open the workbook(A) I'm asked for the password to open workbook(B)..

Is there anyway to prevent this knowing that these linked cells only need to be viewed and not modified...

Thanks a lot..

 

[GlennUK]

If the workbook(B) can be opened read-only you wouldn't have a problem. If you can't open workbook(B) because you don't have the password, then it sounds suspiciously like you are trying to break into someones protected workbook.

 

[Jonmo1]

Yep, that would kinda defeat the purpose of Password Protecting a Workbook...

 

[elaiwa]

Yes but the protected workbook contains some cells that should be viewable for public and some other cells that shouldn't be so....

I can leave the Workbook(B) un protected but can I password protect some sheets inside this Workbook(B) and make them unviewable except if a password is entered..

Is this possible??

 

[GlennUK]

You can have sheets hidden ( xlVeryHidden ), and only unhide them via a macro which prompts for a particular string before processing. Remember to rehide the sheets as xlVeryHidden in the BeforeSave event.

P.S. also remember to protect your VBA project too.

 

[elaiwa]

Thanks a lot