ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Disable a file from searching for a link update on a different user'scomputer (https://www.excelbanter.com/excel-programming/432507-disable-file-searching-link-update-different-userscomputer.html)

Michael Lanier

Disable a file from searching for a link update on a different user'scomputer
 
When I send a file containing macros to another computer it prompts
the user to search for link updates if they have Excel on their
computer. I would like to disable this prompt since nothing my file
contains needs to be updated. (However, it is possible one of my
file's worksheets will require the updating feature in the future, but
not now.) Is there a macro that will accomplish this? Thanks.

Michael

Dave Peterson

Disable a file from searching for a link update on a differentuser's computer
 
I would convert the formulas to values and share that version of the workbook.

You could convert all the formulas or if it's important, just the cells that
contain UDFs that are in your other workbook/addin.

Michael Lanier wrote:

When I send a file containing macros to another computer it prompts
the user to search for link updates if they have Excel on their
computer. I would like to disable this prompt since nothing my file
contains needs to be updated. (However, it is possible one of my
file's worksheets will require the updating feature in the future, but
not now.) Is there a macro that will accomplish this? Thanks.

Michael


--

Dave Peterson


All times are GMT +1. The time now is 10:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com