How to skip confirmation for macro and update all links?

E

Eric

When I open an excel file, I need to confirm macro and update all link by
clicking a button before it opens, does anyone have any suggestions on how to
skip this process only on specific file only? which I trust.
Thanks in advance for any suggestions
Eric
 
K

Ken Warthen

Eric,

Is there any reason you can't save the workbook as a macro enabled workbook?
What version of Excel are you using?

Ken
 
E

Eric

I am using XP with SP3, IE8, Office 2003,
Could you please tell me how to save the workbook as a macro enabled
workbook? I have saved related coding under ThisWorkbook within macro, does
it save as macro enabled workbook?
Do you have any suggestions?
Thanks in advance for any suggestions
Eric
 
S

Shane Devenshire

First, macro enabling is not relevant to the issue (even in 2007). But in
2003 there is not such thing as macro enabled workbooks. You can enable a
macro when you open the workbook but by definition if a 2007 file is macro
enabled it can contain macros, which is a separate issue from running them.

You could set the security level to "low" - Tools, Macros, Security but
this is not generally recommended.

In 2007 you can place files in a trusted location but I don't know if you
can do that in 2003.

You can define the published of a file as trusted in 2003 - you should look
at the help system for that. Regarding links, you should open the file with
the links and choose View, Links, Startup Prompt and pick the option you want.

However, macros and links are different issues.
 
E

Eric

I am using XP with SP3 and Excel 2003, I have tried the SELFCERT.exe, and it
works, but
for updating links, under Edit > Links, I have specify that
Excel always update links, and save it, when I open it next time, message
box is still pop up for confirmation.

If file1.xls includes link connecting to file2.xls, and
If file2.xls includes link connecting to file3.xls, and
If file3.xls includes link connecting to file4.xls.
I have set option not to display alert and update links for file1.xls, but
when I open file1.xls, message is still pop up for updating confirmation.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top