Disable prompt messages

Hi.
In workbook-A there are cells which are linked to other cells in a different workbook called workbook-B. Workbook be is protected with a pass code so if i open workbook-A with out opening Workbook-B i get promted to enter Workbook-B's pass code.
How can i avoid the prompt? Because if i hit cancel when excel asks me to enter a pass code the linked information doesn't change, i just don't want the headache of getting the prompt message each time if there is no need for it.
Any ideas?
I was thinking of maybe putting this code on the workbook but i'm not having any luck:

Please Login or Register  to view this content.

I think you have the correct line, but you can add these 2 lines and see if they make any difference

Please Login or Register  to view this content.

Originally Posted by AB33

I think you have the correct line, but you can add these 2 lines and see if they make any difference

Please Login or Register  to view this content.

Thanks AB33, and what header do i use? Public Sub......?

AB33, will your code disable all my other macros from running on the workbook?

There is no header, you add these two lines with the one you have.
Public Sub could mean the code is visible thought the project as opposed to private sub

No, It just suppress the message.

Ok so tell me if i'm doing right:
I right click on the sheet and click on "view code" then i double click on "this workbook" in the code window and i put in the following code:

Please Login or Register  to view this content.

What Marc's suggested is like this

Please Login or Register  to view this content.

Or similar to

Please Login or Register  to view this content.

where bkPath is your folder path

AB33, your answer worked, thanks.
I looked into Marc's response and now the whole concept makes sense to me. Thanks Marc.