Block link pop-up

[DarrenCurtis]

I have a spreadsheet which is saved on a restricted drive, the spreadsheet also links to another spreadsheet in the same drive. I will be sending the spreadsheet out to people who do not have access to the restricted drive.

When they open up the spreadsheet from the email, they are prompted to update links. Is there a way using VB code that does not give them the option to update links when opening up the spreadsheet?

 

[GlennUK]

Have you tried changing the update options on the workbook?

Do menu command Tools/Options/Edit and untick the Ask to update automatic links checkbox.

Cheers, Glenn.