software

I am trying to remove the startup prompt that asks if I want to update links
to external workbooks (I want the links to update automatically for this
workbook).

I clicked on Edit -gt; Links...
I clicked quot;Startup Prompt...quot;
I selected quot;Don't display the alert and update linksquot;
I clicked OK, and closed the dialog box.

When I try reopening the workbook, the prompt still comes up.
If you tell excel that you want to be asked before updating links, then excel
will respect that setting:

Tools|options|edit tab
Uncheck quot;Ask to update automatic linksquot;

This is a user-by-user setting--not a workbook setting.

quot;Horatio J. Bilgequot; wrote:
gt;
gt; I am trying to remove the startup prompt that asks if I want to update links
gt; to external workbooks (I want the links to update automatically for this
gt; workbook).
gt;
gt; I clicked on Edit -gt; Links...
gt; I clicked quot;Startup Prompt...quot;
gt; I selected quot;Don't display the alert and update linksquot;
gt; I clicked OK, and closed the dialog box.
gt;
gt; When I try reopening the workbook, the prompt still comes up.

--

Dave Peterson

This is for a workbook that I will be sharing with others. I want to make
sure that everyone's copy automatically updates the links, but I would like
to minimize the number of clicks to open the file.

Currently, they will have to click to enable macros, and then click to
update the links. Some users may be worried by the wording of the update
dialog box (quot;... links can be used to access and share confidential
information without your permission...quot;), and won't update the links.

If users have unchecked the box that you mentioned (Tools|options|edit tab),
it's no problem. But for those that have that box checked, is there a way to
skip the dialog box, and still update the links?

Thanks,
Horatio
Can I force the
quot;Dave Petersonquot; gt; wrote in message
...
gt; If you tell excel that you want to be asked before updating links, then
gt; excel
gt; will respect that setting:
gt;
gt; Tools|options|edit tab
gt; Uncheck quot;Ask to update automatic linksquot;
gt;
gt; This is a user-by-user setting--not a workbook setting.
gt;
gt; quot;Horatio J. Bilgequot; wrote:
gt;gt;
gt;gt; I am trying to remove the startup prompt that asks if I want to update
gt;gt; links
gt;gt; to external workbooks (I want the links to update automatically for this
gt;gt; workbook).
gt;gt;
gt;gt; I clicked on Edit -gt; Links...
gt;gt; I clicked quot;Startup Prompt...quot;
gt;gt; I selected quot;Don't display the alert and update linksquot;
gt;gt; I clicked OK, and closed the dialog box.
gt;gt;
gt;gt; When I try reopening the workbook, the prompt still comes up.
gt;
gt; --
gt;
gt; Dave Peterson
If you want more control:
Try creating a dummy workbook whose only purpose is to open the original
workbook with links updated:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:=quot;c:\my documents\excel\book2.xlsquot;, UpdateLinks:=1
ThisWorkbook.Close savechanges:=False
End Sub

Then your users can open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)

======
You could even give the real workbook a password to open, but don't share it
with the users. Put the password in that macro in the dummy workbook and the
users will be forced to go through your open routine.

quot;Horatio J. Bilgequot; wrote:
gt;
gt; This is for a workbook that I will be sharing with others. I want to make
gt; sure that everyone's copy automatically updates the links, but I would like
gt; to minimize the number of clicks to open the file.
gt;
gt; Currently, they will have to click to enable macros, and then click to
gt; update the links. Some users may be worried by the wording of the update
gt; dialog box (quot;... links can be used to access and share confidential
gt; information without your permission...quot;), and won't update the links.
gt;
gt; If users have unchecked the box that you mentioned (Tools|options|edit tab),
gt; it's no problem. But for those that have that box checked, is there a way to
gt; skip the dialog box, and still update the links?
gt;
gt; Thanks,
gt; Horatio
gt;
gt; Can I force the
gt; quot;Dave Petersonquot; gt; wrote in message
gt; ...
gt; gt; If you tell excel that you want to be asked before updating links, then
gt; gt; excel
gt; gt; will respect that setting:
gt; gt;
gt; gt; Tools|options|edit tab
gt; gt; Uncheck quot;Ask to update automatic linksquot;
gt; gt;
gt; gt; This is a user-by-user setting--not a workbook setting.
gt; gt;
gt; gt; quot;Horatio J. Bilgequot; wrote:
gt; gt;gt;
gt; gt;gt; I am trying to remove the startup prompt that asks if I want to update
gt; gt;gt; links
gt; gt;gt; to external workbooks (I want the links to update automatically for this
gt; gt;gt; workbook).
gt; gt;gt;
gt; gt;gt; I clicked on Edit -gt; Links...
gt; gt;gt; I clicked quot;Startup Prompt...quot;
gt; gt;gt; I selected quot;Don't display the alert and update linksquot;
gt; gt;gt; I clicked OK, and closed the dialog box.
gt; gt;gt;
gt; gt;gt; When I try reopening the workbook, the prompt still comes up.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson

--

Dave Peterson

I had set this project aside for awhile, and I'm just getting back to it.

I like the idea of using a dummy workbook, but it isn't working for me. Here
is what I did:
1. I created the dummy workbook in the same directory as the target file
2. I went to quot;ThisWorkbookquot; in the Visual Basic Editor, and used the code
you provided. I used just the filename of the target file, instead of the
full path, since it was in the same directory. I saved and closed.
3. I opened the dummy workbook. I got a macro warning, and clicked quot;Enable
macros.quot; The dummy workbook opened, and stayed open, and the target workbook
did not open.
4. I edited the code to use the full path to the target file, like you had
in your code, but the result was the same.

~ Horatioquot;Dave Petersonquot; gt; wrote in message
...
gt; If you want more control:
gt; Try creating a dummy workbook whose only purpose is to open the original
gt; workbook with links updated:
gt;
gt; Kind of like:
gt;
gt; Option Explicit
gt; Sub auto_open()
gt; Workbooks.Open Filename:=quot;c:\my documents\excel\book2.xlsquot;,
gt; UpdateLinks:=1
gt; ThisWorkbook.Close savechanges:=False
gt; End Sub
gt;
gt; Then your users can open the dummy workbook and the links will be
gt; refreshed.
gt; (read about that UpdateLinks argument in VBA's help.)
gt;
gt; ======
gt; You could even give the real workbook a password to open, but don't share
gt; it
gt; with the users. Put the password in that macro in the dummy workbook and
gt; the
gt; users will be forced to go through your open routine.
gt;
gt; quot;Horatio J. Bilgequot; wrote:
gt;gt;
gt;gt; This is for a workbook that I will be sharing with others. I want to make
gt;gt; sure that everyone's copy automatically updates the links, but I would
gt;gt; like
gt;gt; to minimize the number of clicks to open the file.
gt;gt;
gt;gt; Currently, they will have to click to enable macros, and then click to
gt;gt; update the links. Some users may be worried by the wording of the update
gt;gt; dialog box (quot;... links can be used to access and share confidential
gt;gt; information without your permission...quot;), and won't update the links.
gt;gt;
gt;gt; If users have unchecked the box that you mentioned (Tools|options|edit
gt;gt; tab),
gt;gt; it's no problem. But for those that have that box checked, is there a way
gt;gt; to
gt;gt; skip the dialog box, and still update the links?
gt;gt;
gt;gt; Thanks,
gt;gt; Horatio
gt;gt;
gt;gt; Can I force the
gt;gt; quot;Dave Petersonquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; If you tell excel that you want to be asked before updating links, then
gt;gt; gt; excel
gt;gt; gt; will respect that setting:
gt;gt; gt;
gt;gt; gt; Tools|options|edit tab
gt;gt; gt; Uncheck quot;Ask to update automatic linksquot;
gt;gt; gt;
gt;gt; gt; This is a user-by-user setting--not a workbook setting.
gt;gt; gt;
gt;gt; gt; quot;Horatio J. Bilgequot; wrote:
gt;gt; gt;gt;
gt;gt; gt;gt; I am trying to remove the startup prompt that asks if I want to update
gt;gt; gt;gt; links
gt;gt; gt;gt; to external workbooks (I want the links to update automatically for
gt;gt; gt;gt; this
gt;gt; gt;gt; workbook).
gt;gt; gt;gt;
gt;gt; gt;gt; I clicked on Edit -gt; Links...
gt;gt; gt;gt; I clicked quot;Startup Prompt...quot;
gt;gt; gt;gt; I selected quot;Don't display the alert and update linksquot;
gt;gt; gt;gt; I clicked OK, and closed the dialog box.
gt;gt; gt;gt;
gt;gt; gt;gt; When I try reopening the workbook, the prompt still comes up.
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt;
gt;gt; gt; Dave Peterson
gt;
gt; --
gt;
gt; Dave Peterson
You have two choices...

#1. Move the subroutine to a General module.
#2. Change the name to Workbook_open.

Auto_open in a general module and workbook_open in the ThisWorkbook module can
accomplish the same sort of things--but you can't mix and match names and
locations.

Ps. I'd use the full path the workbook that you want to open. Else I think
you'll find that excel wants to open a file of that name in the current
directory (sometimes the default location).

quot;Horatio J. Bilgequot; wrote:
gt;
gt; I had set this project aside for awhile, and I'm just getting back to it.
gt;
gt; I like the idea of using a dummy workbook, but it isn't working for me. Here
gt; is what I did:
gt; 1. I created the dummy workbook in the same directory as the target file
gt; 2. I went to quot;ThisWorkbookquot; in the Visual Basic Editor, and used the code
gt; you provided. I used just the filename of the target file, instead of the
gt; full path, since it was in the same directory. I saved and closed.
gt; 3. I opened the dummy workbook. I got a macro warning, and clicked quot;Enable
gt; macros.quot; The dummy workbook opened, and stayed open, and the target workbook
gt; did not open.
gt; 4. I edited the code to use the full path to the target file, like you had
gt; in your code, but the result was the same.
gt;
gt; ~ Horatio
gt;
gt; quot;Dave Petersonquot; gt; wrote in message
gt; ...
gt; gt; If you want more control:
gt; gt; Try creating a dummy workbook whose only purpose is to open the original
gt; gt; workbook with links updated:
gt; gt;
gt; gt; Kind of like:
gt; gt;
gt; gt; Option Explicit
gt; gt; Sub auto_open()
gt; gt; Workbooks.Open Filename:=quot;c:\my documents\excel\book2.xlsquot;,
gt; gt; UpdateLinks:=1
gt; gt; ThisWorkbook.Close savechanges:=False
gt; gt; End Sub
gt; gt;
gt; gt; Then your users can open the dummy workbook and the links will be
gt; gt; refreshed.
gt; gt; (read about that UpdateLinks argument in VBA's help.)
gt; gt;
gt; gt; ======
gt; gt; You could even give the real workbook a password to open, but don't share
gt; gt; it
gt; gt; with the users. Put the password in that macro in the dummy workbook and
gt; gt; the
gt; gt; users will be forced to go through your open routine.
gt; gt;
gt; gt; quot;Horatio J. Bilgequot; wrote:
gt; gt;gt;
gt; gt;gt; This is for a workbook that I will be sharing with others. I want to make
gt; gt;gt; sure that everyone's copy automatically updates the links, but I would
gt; gt;gt; like
gt; gt;gt; to minimize the number of clicks to open the file.
gt; gt;gt;
gt; gt;gt; Currently, they will have to click to enable macros, and then click to
gt; gt;gt; update the links. Some users may be worried by the wording of the update
gt; gt;gt; dialog box (quot;... links can be used to access and share confidential
gt; gt;gt; information without your permission...quot;), and won't update the links.
gt; gt;gt;
gt; gt;gt; If users have unchecked the box that you mentioned (Tools|options|edit
gt; gt;gt; tab),
gt; gt;gt; it's no problem. But for those that have that box checked, is there a way
gt; gt;gt; to
gt; gt;gt; skip the dialog box, and still update the links?
gt; gt;gt;
gt; gt;gt; Thanks,
gt; gt;gt; Horatio
gt; gt;gt;
gt; gt;gt; Can I force the
gt; gt;gt; quot;Dave Petersonquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; If you tell excel that you want to be asked before updating links, then
gt; gt;gt; gt; excel
gt; gt;gt; gt; will respect that setting:
gt; gt;gt; gt;
gt; gt;gt; gt; Tools|options|edit tab
gt; gt;gt; gt; Uncheck quot;Ask to update automatic linksquot;
gt; gt;gt; gt;
gt; gt;gt; gt; This is a user-by-user setting--not a workbook setting.
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Horatio J. Bilgequot; wrote:
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; I am trying to remove the startup prompt that asks if I want to update
gt; gt;gt; gt;gt; links
gt; gt;gt; gt;gt; to external workbooks (I want the links to update automatically for
gt; gt;gt; gt;gt; this
gt; gt;gt; gt;gt; workbook).
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; I clicked on Edit -gt; Links...
gt; gt;gt; gt;gt; I clicked quot;Startup Prompt...quot;
gt; gt;gt; gt;gt; I selected quot;Don't display the alert and update linksquot;
gt; gt;gt; gt;gt; I clicked OK, and closed the dialog box.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; When I try reopening the workbook, the prompt still comes up.
gt; gt;gt; gt;
gt; gt;gt; gt; --
gt; gt;gt; gt;
gt; gt;gt; gt; Dave Peterson
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson

--

Dave Peterson

Thanks.
I wasn't certain what you meant by changing it to a general module, but I
changed the name to workbook_open, and it works fine.

Is there a way to use a relative file path, rather than the full path? Even
if all users put the file in the same place, the full path is different for
each user. For example, if everyone puts it in their My Documents folder,
the full path on Windows XP would be:
quot;C:\Documents and Settings\[User Name]\My Documentsquot;

Thanks,
~ Horatio

quot;Dave Petersonquot; gt; wrote in message
...
gt; You have two choices...
gt;
gt; #1. Move the subroutine to a General module.
gt; #2. Change the name to Workbook_open.
gt;
gt; Auto_open in a general module and workbook_open in the ThisWorkbook module
gt; can
gt; accomplish the same sort of things--but you can't mix and match names and
gt; locations.
gt;
gt; Ps. I'd use the full path the workbook that you want to open. Else I
gt; think
gt; you'll find that excel wants to open a file of that name in the current
gt; directory (sometimes the default location).
gt;
gt; quot;Horatio J. Bilgequot; wrote:
gt;gt;
gt;gt; I had set this project aside for awhile, and I'm just getting back to it.
gt;gt;
gt;gt; I like the idea of using a dummy workbook, but it isn't working for me.
gt;gt; Here
gt;gt; is what I did:
gt;gt; 1. I created the dummy workbook in the same directory as the target file
gt;gt; 2. I went to quot;ThisWorkbookquot; in the Visual Basic Editor, and used the code
gt;gt; you provided. I used just the filename of the target file, instead of the
gt;gt; full path, since it was in the same directory. I saved and closed.
gt;gt; 3. I opened the dummy workbook. I got a macro warning, and clicked
gt;gt; quot;Enable
gt;gt; macros.quot; The dummy workbook opened, and stayed open, and the target
gt;gt; workbook
gt;gt; did not open.
gt;gt; 4. I edited the code to use the full path to the target file, like you
gt;gt; had
gt;gt; in your code, but the result was the same.
gt;gt;
gt;gt; ~ Horatio
gt;gt;
gt;gt; quot;Dave Petersonquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; If you want more control:
gt;gt; gt; Try creating a dummy workbook whose only purpose is to open the
gt;gt; gt; original
gt;gt; gt; workbook with links updated:
gt;gt; gt;
gt;gt; gt; Kind of like:
gt;gt; gt;
gt;gt; gt; Option Explicit
gt;gt; gt; Sub auto_open()
gt;gt; gt; Workbooks.Open Filename:=quot;c:\my documents\excel\book2.xlsquot;,
gt;gt; gt; UpdateLinks:=1
gt;gt; gt; ThisWorkbook.Close savechanges:=False
gt;gt; gt; End Sub
gt;gt; gt;
gt;gt; gt; Then your users can open the dummy workbook and the links will be
gt;gt; gt; refreshed.
gt;gt; gt; (read about that UpdateLinks argument in VBA's help.)
gt;gt; gt;
gt;gt; gt; ======
gt;gt; gt; You could even give the real workbook a password to open, but don't
gt;gt; gt; share
gt;gt; gt; it
gt;gt; gt; with the users. Put the password in that macro in the dummy workbook
gt;gt; gt; and
gt;gt; gt; the
gt;gt; gt; users will be forced to go through your open routine.
gt;gt; gt;
gt;gt; gt; quot;Horatio J. Bilgequot; wrote:
gt;gt; gt;gt;
gt;gt; gt;gt; This is for a workbook that I will be sharing with others. I want to
gt;gt; gt;gt; make
gt;gt; gt;gt; sure that everyone's copy automatically updates the links, but I would
gt;gt; gt;gt; like
gt;gt; gt;gt; to minimize the number of clicks to open the file.
gt;gt; gt;gt;
gt;gt; gt;gt; Currently, they will have to click to enable macros, and then click to
gt;gt; gt;gt; update the links. Some users may be worried by the wording of the
gt;gt; gt;gt; update
gt;gt; gt;gt; dialog box (quot;... links can be used to access and share confidential
gt;gt; gt;gt; information without your permission...quot;), and won't update the links.
gt;gt; gt;gt;
gt;gt; gt;gt; If users have unchecked the box that you mentioned (Tools|options|edit
gt;gt; gt;gt; tab),
gt;gt; gt;gt; it's no problem. But for those that have that box checked, is there a
gt;gt; gt;gt; way
gt;gt; gt;gt; to
gt;gt; gt;gt; skip the dialog box, and still update the links?
gt;gt; gt;gt;
gt;gt; gt;gt; Thanks,
gt;gt; gt;gt; Horatio
gt;gt; gt;gt;
gt;gt; gt;gt; Can I force the
gt;gt; gt;gt; quot;Dave Petersonquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; If you tell excel that you want to be asked before updating links,
gt;gt; gt;gt; gt; then
gt;gt; gt;gt; gt; excel
gt;gt; gt;gt; gt; will respect that setting:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Tools|options|edit tab
gt;gt; gt;gt; gt; Uncheck quot;Ask to update automatic linksquot;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; This is a user-by-user setting--not a workbook setting.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; quot;Horatio J. Bilgequot; wrote:
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; I am trying to remove the startup prompt that asks if I want to
gt;gt; gt;gt; gt;gt; update
gt;gt; gt;gt; gt;gt; links
gt;gt; gt;gt; gt;gt; to external workbooks (I want the links to update automatically for
gt;gt; gt;gt; gt;gt; this
gt;gt; gt;gt; gt;gt; workbook).
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; I clicked on Edit -gt; Links...
gt;gt; gt;gt; gt;gt; I clicked quot;Startup Prompt...quot;
gt;gt; gt;gt; gt;gt; I selected quot;Don't display the alert and update linksquot;
gt;gt; gt;gt; gt;gt; I clicked OK, and closed the dialog box.
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; When I try reopening the workbook, the prompt still comes up.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; --
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Dave Peterson
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt;
gt;gt; gt; Dave Peterson
gt;
gt; --
gt;
gt; Dave Peterson
A general module is inserted in the VBE via: Insert|module.

It's not the ThisWorkbook and it's not behind a worksheet.

You could just use that same folder as the workbook that owns the code:

Workbooks.Open Filename:=thisworkbook.path amp; quot;\quot; amp; quot;book2.xlsquot;quot;Horatio J. Bilgequot; wrote:
gt;
gt; Thanks.
gt; I wasn't certain what you meant by changing it to a general module, but I
gt; changed the name to workbook_open, and it works fine.
gt;
gt; Is there a way to use a relative file path, rather than the full path? Even
gt; if all users put the file in the same place, the full path is different for
gt; each user. For example, if everyone puts it in their My Documents folder,
gt; the full path on Windows XP would be:
gt; quot;C:\Documents and Settings\[User Name]\My Documentsquot;
gt;
gt; Thanks,
gt; ~ Horatio
gt;
gt; quot;Dave Petersonquot; gt; wrote in message
gt; ...
gt; gt; You have two choices...
gt; gt;
gt; gt; #1. Move the subroutine to a General module.
gt; gt; #2. Change the name to Workbook_open.
gt; gt;
gt; gt; Auto_open in a general module and workbook_open in the ThisWorkbook module
gt; gt; can
gt; gt; accomplish the same sort of things--but you can't mix and match names and
gt; gt; locations.
gt; gt;
gt; gt; Ps. I'd use the full path the workbook that you want to open. Else I
gt; gt; think
gt; gt; you'll find that excel wants to open a file of that name in the current
gt; gt; directory (sometimes the default location).
gt; gt;
gt; gt; quot;Horatio J. Bilgequot; wrote:
gt; gt;gt;
gt; gt;gt; I had set this project aside for awhile, and I'm just getting back to it.
gt; gt;gt;
gt; gt;gt; I like the idea of using a dummy workbook, but it isn't working for me.
gt; gt;gt; Here
gt; gt;gt; is what I did:
gt; gt;gt; 1. I created the dummy workbook in the same directory as the target file
gt; gt;gt; 2. I went to quot;ThisWorkbookquot; in the Visual Basic Editor, and used the code
gt; gt;gt; you provided. I used just the filename of the target file, instead of the
gt; gt;gt; full path, since it was in the same directory. I saved and closed.
gt; gt;gt; 3. I opened the dummy workbook. I got a macro warning, and clicked
gt; gt;gt; quot;Enable
gt; gt;gt; macros.quot; The dummy workbook opened, and stayed open, and the target
gt; gt;gt; workbook
gt; gt;gt; did not open.
gt; gt;gt; 4. I edited the code to use the full path to the target file, like you
gt; gt;gt; had
gt; gt;gt; in your code, but the result was the same.
gt; gt;gt;
gt; gt;gt; ~ Horatio
gt; gt;gt;
gt; gt;gt; quot;Dave Petersonquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; If you want more control:
gt; gt;gt; gt; Try creating a dummy workbook whose only purpose is to open the
gt; gt;gt; gt; original
gt; gt;gt; gt; workbook with links updated:
gt; gt;gt; gt;
gt; gt;gt; gt; Kind of like:
gt; gt;gt; gt;
gt; gt;gt; gt; Option Explicit
gt; gt;gt; gt; Sub auto_open()
gt; gt;gt; gt; Workbooks.Open Filename:=quot;c:\my documents\excel\book2.xlsquot;,
gt; gt;gt; gt; UpdateLinks:=1
gt; gt;gt; gt; ThisWorkbook.Close savechanges:=False
gt; gt;gt; gt; End Sub
gt; gt;gt; gt;
gt; gt;gt; gt; Then your users can open the dummy workbook and the links will be
gt; gt;gt; gt; refreshed.
gt; gt;gt; gt; (read about that UpdateLinks argument in VBA's help.)
gt; gt;gt; gt;
gt; gt;gt; gt; ======
gt; gt;gt; gt; You could even give the real workbook a password to open, but don't
gt; gt;gt; gt; share
gt; gt;gt; gt; it
gt; gt;gt; gt; with the users. Put the password in that macro in the dummy workbook
gt; gt;gt; gt; and
gt; gt;gt; gt; the
gt; gt;gt; gt; users will be forced to go through your open routine.
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Horatio J. Bilgequot; wrote:
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; This is for a workbook that I will be sharing with others. I want to
gt; gt;gt; gt;gt; make
gt; gt;gt; gt;gt; sure that everyone's copy automatically updates the links, but I would
gt; gt;gt; gt;gt; like
gt; gt;gt; gt;gt; to minimize the number of clicks to open the file.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Currently, they will have to click to enable macros, and then click to
gt; gt;gt; gt;gt; update the links. Some users may be worried by the wording of the
gt; gt;gt; gt;gt; update
gt; gt;gt; gt;gt; dialog box (quot;... links can be used to access and share confidential
gt; gt;gt; gt;gt; information without your permission...quot;), and won't update the links.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; If users have unchecked the box that you mentioned (Tools|options|edit
gt; gt;gt; gt;gt; tab),
gt; gt;gt; gt;gt; it's no problem. But for those that have that box checked, is there a
gt; gt;gt; gt;gt; way
gt; gt;gt; gt;gt; to
gt; gt;gt; gt;gt; skip the dialog box, and still update the links?
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Thanks,
gt; gt;gt; gt;gt; Horatio
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; Can I force the
gt; gt;gt; gt;gt; quot;Dave Petersonquot; gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt; If you tell excel that you want to be asked before updating links,
gt; gt;gt; gt;gt; gt; then
gt; gt;gt; gt;gt; gt; excel
gt; gt;gt; gt;gt; gt; will respect that setting:
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Tools|options|edit tab
gt; gt;gt; gt;gt; gt; Uncheck quot;Ask to update automatic linksquot;
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; This is a user-by-user setting--not a workbook setting.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; quot;Horatio J. Bilgequot; wrote:
gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt; I am trying to remove the startup prompt that asks if I want to
gt; gt;gt; gt;gt; gt;gt; update
gt; gt;gt; gt;gt; gt;gt; links
gt; gt;gt; gt;gt; gt;gt; to external workbooks (I want the links to update automatically for
gt; gt;gt; gt;gt; gt;gt; this
gt; gt;gt; gt;gt; gt;gt; workbook).
gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt; I clicked on Edit -gt; Links...
gt; gt;gt; gt;gt; gt;gt; I clicked quot;Startup Prompt...quot;
gt; gt;gt; gt;gt; gt;gt; I selected quot;Don't display the alert and update linksquot;
gt; gt;gt; gt;gt; gt;gt; I clicked OK, and closed the dialog box.
gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt; When I try reopening the workbook, the prompt still comes up.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; --
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Dave Peterson
gt; gt;gt; gt;
gt; gt;gt; gt; --
gt; gt;gt; gt;
gt; gt;gt; gt; Dave Peterson
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson

--

Dave Peterson

Dave,

Thank you for your help. I've got it working well, now. Here is the final
code I used in the dummy file:

Option Explicit
Sub workbook_open()
Workbooks.Open Filename:=ThisWorkbook.Path amp; quot;\quot; amp; quot;book2.xlsquot;,
UpdateLinks:=1, Password:=quot;GreatPasswordquot;
ThisWorkbook.Close savechanges:=False
End Sub

Thanks again,
~ Horatioquot;Dave Petersonquot; gt; wrote in message
...
gt;A general module is inserted in the VBE via: Insert|module.
gt;
gt; It's not the ThisWorkbook and it's not behind a worksheet.
gt;
gt; You could just use that same folder as the workbook that owns the code:
gt;
gt; Workbooks.Open Filename:=thisworkbook.path amp; quot;\quot; amp; quot;book2.xlsquot;
gt;
gt;
gt;
gt;
gt;
gt; quot;Horatio J. Bilgequot; wrote:
gt;gt;
gt;gt; Thanks.
gt;gt; I wasn't certain what you meant by changing it to a general module, but I
gt;gt; changed the name to workbook_open, and it works fine.
gt;gt;
gt;gt; Is there a way to use a relative file path, rather than the full path?
gt;gt; Even
gt;gt; if all users put the file in the same place, the full path is different
gt;gt; for
gt;gt; each user. For example, if everyone puts it in their My Documents folder,
gt;gt; the full path on Windows XP would be:
gt;gt; quot;C:\Documents and Settings\[User Name]\My Documentsquot;
gt;gt;
gt;gt; Thanks,
gt;gt; ~ Horatio
gt;gt;
gt;gt; quot;Dave Petersonquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; You have two choices...
gt;gt; gt;
gt;gt; gt; #1. Move the subroutine to a General module.
gt;gt; gt; #2. Change the name to Workbook_open.
gt;gt; gt;
gt;gt; gt; Auto_open in a general module and workbook_open in the ThisWorkbook
gt;gt; gt; module
gt;gt; gt; can
gt;gt; gt; accomplish the same sort of things--but you can't mix and match names
gt;gt; gt; and
gt;gt; gt; locations.
gt;gt; gt;
gt;gt; gt; Ps. I'd use the full path the workbook that you want to open. Else I
gt;gt; gt; think
gt;gt; gt; you'll find that excel wants to open a file of that name in the current
gt;gt; gt; directory (sometimes the default location).
gt;gt; gt;
gt;gt; gt; quot;Horatio J. Bilgequot; wrote:
gt;gt; gt;gt;
gt;gt; gt;gt; I had set this project aside for awhile, and I'm just getting back to
gt;gt; gt;gt; it.
gt;gt; gt;gt;
gt;gt; gt;gt; I like the idea of using a dummy workbook, but it isn't working for
gt;gt; gt;gt; me.
gt;gt; gt;gt; Here
gt;gt; gt;gt; is what I did:
gt;gt; gt;gt; 1. I created the dummy workbook in the same directory as the target
gt;gt; gt;gt; file
gt;gt; gt;gt; 2. I went to quot;ThisWorkbookquot; in the Visual Basic Editor, and used the
gt;gt; gt;gt; code
gt;gt; gt;gt; you provided. I used just the filename of the target file, instead of
gt;gt; gt;gt; the
gt;gt; gt;gt; full path, since it was in the same directory. I saved and closed.
gt;gt; gt;gt; 3. I opened the dummy workbook. I got a macro warning, and clicked
gt;gt; gt;gt; quot;Enable
gt;gt; gt;gt; macros.quot; The dummy workbook opened, and stayed open, and the target
gt;gt; gt;gt; workbook
gt;gt; gt;gt; did not open.
gt;gt; gt;gt; 4. I edited the code to use the full path to the target file, like you
gt;gt; gt;gt; had
gt;gt; gt;gt; in your code, but the result was the same.
gt;gt; gt;gt;
gt;gt; gt;gt; ~ Horatio
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Dave Petersonquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; If you want more control:
gt;gt; gt;gt; gt; Try creating a dummy workbook whose only purpose is to open the
gt;gt; gt;gt; gt; original
gt;gt; gt;gt; gt; workbook with links updated:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Kind of like:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Option Explicit
gt;gt; gt;gt; gt; Sub auto_open()
gt;gt; gt;gt; gt; Workbooks.Open Filename:=quot;c:\my documents\excel\book2.xlsquot;,
gt;gt; gt;gt; gt; UpdateLinks:=1
gt;gt; gt;gt; gt; ThisWorkbook.Close savechanges:=False
gt;gt; gt;gt; gt; End Sub
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Then your users can open the dummy workbook and the links will be
gt;gt; gt;gt; gt; refreshed.
gt;gt; gt;gt; gt; (read about that UpdateLinks argument in VBA's help.)
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; ======
gt;gt; gt;gt; gt; You could even give the real workbook a password to open, but don't
gt;gt; gt;gt; gt; share
gt;gt; gt;gt; gt; it
gt;gt; gt;gt; gt; with the users. Put the password in that macro in the dummy
gt;gt; gt;gt; gt; workbook
gt;gt; gt;gt; gt; and
gt;gt; gt;gt; gt; the
gt;gt; gt;gt; gt; users will be forced to go through your open routine.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; quot;Horatio J. Bilgequot; wrote:
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; This is for a workbook that I will be sharing with others. I want
gt;gt; gt;gt; gt;gt; to
gt;gt; gt;gt; gt;gt; make
gt;gt; gt;gt; gt;gt; sure that everyone's copy automatically updates the links, but I
gt;gt; gt;gt; gt;gt; would
gt;gt; gt;gt; gt;gt; like
gt;gt; gt;gt; gt;gt; to minimize the number of clicks to open the file.
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Currently, they will have to click to enable macros, and then click
gt;gt; gt;gt; gt;gt; to
gt;gt; gt;gt; gt;gt; update the links. Some users may be worried by the wording of the
gt;gt; gt;gt; gt;gt; update
gt;gt; gt;gt; gt;gt; dialog box (quot;... links can be used to access and share confidential
gt;gt; gt;gt; gt;gt; information without your permission...quot;), and won't update the
gt;gt; gt;gt; gt;gt; links.
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; If users have unchecked the box that you mentioned
gt;gt; gt;gt; gt;gt; (Tools|options|edit
gt;gt; gt;gt; gt;gt; tab),
gt;gt; gt;gt; gt;gt; it's no problem. But for those that have that box checked, is there
gt;gt; gt;gt; gt;gt; a
gt;gt; gt;gt; gt;gt; way
gt;gt; gt;gt; gt;gt; to
gt;gt; gt;gt; gt;gt; skip the dialog box, and still update the links?
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Thanks,
gt;gt; gt;gt; gt;gt; Horatio
gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; Can I force the
gt;gt; gt;gt; gt;gt; quot;Dave Petersonquot; gt; wrote in message
gt;gt; gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;gt; gt; If you tell excel that you want to be asked before updating
gt;gt; gt;gt; gt;gt; gt; links,
gt;gt; gt;gt; gt;gt; gt; then
gt;gt; gt;gt; gt;gt; gt; excel
gt;gt; gt;gt; gt;gt; gt; will respect that setting:
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; Tools|options|edit tab
gt;gt; gt;gt; gt;gt; gt; Uncheck quot;Ask to update automatic linksquot;
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; This is a user-by-user setting--not a workbook setting.
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; quot;Horatio J. Bilgequot; wrote:
gt;gt; gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; gt;gt; I am trying to remove the startup prompt that asks if I want to
gt;gt; gt;gt; gt;gt; gt;gt; update
gt;gt; gt;gt; gt;gt; gt;gt; links
gt;gt; gt;gt; gt;gt; gt;gt; to external workbooks (I want the links to update automatically
gt;gt; gt;gt; gt;gt; gt;gt; for
gt;gt; gt;gt; gt;gt; gt;gt; this
gt;gt; gt;gt; gt;gt; gt;gt; workbook).
gt;gt; gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; gt;gt; I clicked on Edit -gt; Links...
gt;gt; gt;gt; gt;gt; gt;gt; I clicked quot;Startup Prompt...quot;
gt;gt; gt;gt; gt;gt; gt;gt; I selected quot;Don't display the alert and update linksquot;
gt;gt; gt;gt; gt;gt; gt;gt; I clicked OK, and closed the dialog box.
gt;gt; gt;gt; gt;gt; gt;gt;
gt;gt; gt;gt; gt;gt; gt;gt; When I try reopening the workbook, the prompt still comes up.
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; --
gt;gt; gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;gt; gt; Dave Peterson
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; --
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Dave Peterson
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt;
gt;gt; gt; Dave Peterson
gt;
gt; --
gt;
gt; Dave Peterson
You may want to protect your project to keep that password a secret from others.

Tools|VBAProject Properties|Protection tab (inside the VBE)

quot;Horatio J. Bilgequot; wrote:
gt;
gt; Dave,
gt;
gt; Thank you for your help. I've got it working well, now. Here is the final
gt; code I used in the dummy file:
gt;
gt; Option Explicit
gt; Sub workbook_open()
gt; Workbooks.Open Filename:=ThisWorkbook.Path amp; quot;\quot; amp; quot;book2.xlsquot;,
gt; UpdateLinks:=1, Password:=quot;GreatPasswordquot;
gt; ThisWorkbook.Close savechanges:=False
gt; End Sub
gt;
gt; Thanks again,
gt; ~ Horatio
gt;
gt; quot;Dave Petersonquot; gt; wrote in message
gt; ...
gt; gt;A general module is inserted in the VBE via: Insert|module.
gt; gt;
gt; gt; It's not the ThisWorkbook and it's not behind a worksheet.
gt; gt;
gt; gt; You could just use that same folder as the workbook that owns the code:
gt; gt;
gt; gt; Workbooks.Open Filename:=thisworkbook.path amp; quot;\quot; amp; quot;book2.xlsquot;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Horatio J. Bilgequot; wrote:
gt; gt;gt;
gt; gt;gt; Thanks.
gt; gt;gt; I wasn't certain what you meant by changing it to a general module, but I
gt; gt;gt; changed the name to workbook_open, and it works fine.
gt; gt;gt;
gt; gt;gt; Is there a way to use a relative file path, rather than the full path?
gt; gt;gt; Even
gt; gt;gt; if all users put the file in the same place, the full path is different
gt; gt;gt; for
gt; gt;gt; each user. For example, if everyone puts it in their My Documents folder,
gt; gt;gt; the full path on Windows XP would be:
gt; gt;gt; quot;C:\Documents and Settings\[User Name]\My Documentsquot;
gt; gt;gt;
gt; gt;gt; Thanks,
gt; gt;gt; ~ Horatio
gt; gt;gt;
gt; gt;gt; quot;Dave Petersonquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; You have two choices...
gt; gt;gt; gt;
gt; gt;gt; gt; #1. Move the subroutine to a General module.
gt; gt;gt; gt; #2. Change the name to Workbook_open.
gt; gt;gt; gt;
gt; gt;gt; gt; Auto_open in a general module and workbook_open in the ThisWorkbook
gt; gt;gt; gt; module
gt; gt;gt; gt; can
gt; gt;gt; gt; accomplish the same sort of things--but you can't mix and match names
gt; gt;gt; gt; and
gt; gt;gt; gt; locations.
gt; gt;gt; gt;
gt; gt;gt; gt; Ps. I'd use the full path the workbook that you want to open. Else I
gt; gt;gt; gt; think
gt; gt;gt; gt; you'll find that excel wants to open a file of that name in the current
gt; gt;gt; gt; directory (sometimes the default location).
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Horatio J. Bilgequot; wrote:
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; I had set this project aside for awhile, and I'm just getting back to
gt; gt;gt; gt;gt; it.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; I like the idea of using a dummy workbook, but it isn't working for
gt; gt;gt; gt;gt; me.
gt; gt;gt; gt;gt; Here
gt; gt;gt; gt;gt; is what I did:
gt; gt;gt; gt;gt; 1. I created the dummy workbook in the same directory as the target
gt; gt;gt; gt;gt; file
gt; gt;gt; gt;gt; 2. I went to quot;ThisWorkbookquot; in the Visual Basic Editor, and used the
gt; gt;gt; gt;gt; code
gt; gt;gt; gt;gt; you provided. I used just the filename of the target file, instead of
gt; gt;gt; gt;gt; the
gt; gt;gt; gt;gt; full path, since it was in the same directory. I saved and closed.
gt; gt;gt; gt;gt; 3. I opened the dummy workbook. I got a macro warning, and clicked
gt; gt;gt; gt;gt; quot;Enable
gt; gt;gt; gt;gt; macros.quot; The dummy workbook opened, and stayed open, and the target
gt; gt;gt; gt;gt; workbook
gt; gt;gt; gt;gt; did not open.
gt; gt;gt; gt;gt; 4. I edited the code to use the full path to the target file, like you
gt; gt;gt; gt;gt; had
gt; gt;gt; gt;gt; in your code, but the result was the same.
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; ~ Horatio
gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; quot;Dave Petersonquot; gt; wrote in message
gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt; If you want more control:
gt; gt;gt; gt;gt; gt; Try creating a dummy workbook whose only purpose is to open the
gt; gt;gt; gt;gt; gt; original
gt; gt;gt; gt;gt; gt; workbook with links updated:
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Kind of like:
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Option Explicit
gt; gt;gt; gt;gt; gt; Sub auto_open()
gt; gt;gt; gt;gt; gt; Workbooks.Open Filename:=quot;c:\my documents\excel\book2.xlsquot;,
gt; gt;gt; gt;gt; gt; UpdateLinks:=1
gt; gt;gt; gt;gt; gt; ThisWorkbook.Close savechanges:=False
gt; gt;gt; gt;gt; gt; End Sub
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Then your users can open the dummy workbook and the links will be
gt; gt;gt; gt;gt; gt; refreshed.
gt; gt;gt; gt;gt; gt; (read about that UpdateLinks argument in VBA's help.)
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; ======
gt; gt;gt; gt;gt; gt; You could even give the real workbook a password to open, but don't
gt; gt;gt; gt;gt; gt; share
gt; gt;gt; gt;gt; gt; it
gt; gt;gt; gt;gt; gt; with the users. Put the password in that macro in the dummy
gt; gt;gt; gt;gt; gt; workbook
gt; gt;gt; gt;gt; gt; and
gt; gt;gt; gt;gt; gt; the
gt; gt;gt; gt;gt; gt; users will be forced to go through your open routine.
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; quot;Horatio J. Bilgequot; wrote:
gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt; This is for a workbook that I will be sharing with others. I want
gt; gt;gt; gt;gt; gt;gt; to
gt; gt;gt; gt;gt; gt;gt; make
gt; gt;gt; gt;gt; gt;gt; sure that everyone's copy automatically updates the links, but I
gt; gt;gt; gt;gt; gt;gt; would
gt; gt;gt; gt;gt; gt;gt; like
gt; gt;gt; gt;gt; gt;gt; to minimize the number of clicks to open the file.
gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt; Currently, they will have to click to enable macros, and then click
gt; gt;gt; gt;gt; gt;gt; to
gt; gt;gt; gt;gt; gt;gt; update the links. Some users may be worried by the wording of the
gt; gt;gt; gt;gt; gt;gt; update
gt; gt;gt; gt;gt; gt;gt; dialog box (quot;... links can be used to access and share confidential
gt; gt;gt; gt;gt; gt;gt; information without your permission...quot;), and won't update the
gt; gt;gt; gt;gt; gt;gt; links.
gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt; If users have unchecked the box that you mentioned
gt; gt;gt; gt;gt; gt;gt; (Tools|options|edit
gt; gt;gt; gt;gt; gt;gt; tab),
gt; gt;gt; gt;gt; gt;gt; it's no problem. But for those that have that box checked, is there
gt; gt;gt; gt;gt; gt;gt; a
gt; gt;gt; gt;gt; gt;gt; way
gt; gt;gt; gt;gt; gt;gt; to
gt; gt;gt; gt;gt; gt;gt; skip the dialog box, and still update the links?
gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt; Thanks,
gt; gt;gt; gt;gt; gt;gt; Horatio
gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt; Can I force the
gt; gt;gt; gt;gt; gt;gt; quot;Dave Petersonquot; gt; wrote in message
gt; gt;gt; gt;gt; gt;gt; ...
gt; gt;gt; gt;gt; gt;gt; gt; If you tell excel that you want to be asked before updating
gt; gt;gt; gt;gt; gt;gt; gt; links,
gt; gt;gt; gt;gt; gt;gt; gt; then
gt; gt;gt; gt;gt; gt;gt; gt; excel
gt; gt;gt; gt;gt; gt;gt; gt; will respect that setting:
gt; gt;gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt;gt; gt; Tools|options|edit tab
gt; gt;gt; gt;gt; gt;gt; gt; Uncheck quot;Ask to update automatic linksquot;
gt; gt;gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt;gt; gt; This is a user-by-user setting--not a workbook setting.
gt; gt;gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt;gt; gt; quot;Horatio J. Bilgequot; wrote:
gt; gt;gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt; gt;gt; I am trying to remove the startup prompt that asks if I want to
gt; gt;gt; gt;gt; gt;gt; gt;gt; update
gt; gt;gt; gt;gt; gt;gt; gt;gt; links
gt; gt;gt; gt;gt; gt;gt; gt;gt; to external workbooks (I want the links to update automatically
gt; gt;gt; gt;gt; gt;gt; gt;gt; for
gt; gt;gt; gt;gt; gt;gt; gt;gt; this
gt; gt;gt; gt;gt; gt;gt; gt;gt; workbook).
gt; gt;gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt; gt;gt; I clicked on Edit -gt; Links...
gt; gt;gt; gt;gt; gt;gt; gt;gt; I clicked quot;Startup Prompt...quot;
gt; gt;gt; gt;gt; gt;gt; gt;gt; I selected quot;Don't display the alert and update linksquot;
gt; gt;gt; gt;gt; gt;gt; gt;gt; I clicked OK, and closed the dialog box.
gt; gt;gt; gt;gt; gt;gt; gt;gt;
gt; gt;gt; gt;gt; gt;gt; gt;gt; When I try reopening the workbook, the prompt still comes up.
gt; gt;gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt;gt; gt; --
gt; gt;gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt;gt; gt; Dave Peterson
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; --
gt; gt;gt; gt;gt; gt;
gt; gt;gt; gt;gt; gt; Dave Peterson
gt; gt;gt; gt;
gt; gt;gt; gt; --
gt; gt;gt; gt;
gt; gt;gt; gt; Dave Peterson
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson

--

Dave Peterson