Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching VBA code to disable excel compatibilty checker bartvd Excel Programming 1 June 11th 09 02:19 PM
Excel cell can't update link in the file in sharepoint 2007 [email protected] Links and Linking in Excel 0 January 3rd 08 12:11 AM
How to disable 'Update alert' when open a spreadsheet has link to other XLS Chong Moua Excel Programming 0 July 9th 03 11:59 PM
How to disable 'Update alert' when open a spreadsheet has link to other XLS andres a Excel Programming 0 July 9th 03 11:26 PM
How to disable 'Update alert' when open a spreadsheet has link to other XLS Jose Rojas Excel Programming 0 July 9th 03 11:14 PM


All times are GMT +1. The time now is 06:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"