PC Review


Reply
Thread Tools Rate Thread

Disable a file from searching for a link update on a different user'scomputer

 
 
Michael Lanier
Guest
Posts: n/a
 
      17th Aug 2009
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
 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      17th Aug 2009
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching for a Specific Update with Batch File DaDuck Windows XP Security 3 31st Mar 2009 06:57 PM
file search -how to disable searching thru zip & cab files   Windows XP Customization 3 13th Aug 2003 08:47 PM
How to disable 'Update alert' when open a spreadsheet has link to other XLS Chong Moua Microsoft Excel Programming 0 9th Jul 2003 11:59 PM
How to disable 'Update alert' when open a spreadsheet has link to other XLS andres a Microsoft Excel Programming 0 9th Jul 2003 11:26 PM
Re: How to disable 'Update alert' when open a spreadsheet has link to other XLS Jose Rojas Microsoft Excel Programming 0 9th Jul 2003 11:14 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:58 AM.