Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching VBA code to disable excel compatibilty checker | Excel Programming | |||
Excel cell can't update link in the file in sharepoint 2007 | Links and Linking in Excel | |||
How to disable 'Update alert' when open a spreadsheet has link to other XLS | Excel Programming | |||
How to disable 'Update alert' when open a spreadsheet has link to other XLS | Excel Programming | |||
How to disable 'Update alert' when open a spreadsheet has link to other XLS | Excel Programming |