Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to skip confirmation for macro and update all links?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to skip confirmation for macro and update all links?
Eric,
Is there any reason you can't save the workbook as a macro enabled workbook? What version of Excel are you using? Ken "Eric" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to skip confirmation for macro and update all links?
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 "Ken Warthen" wrote: Eric, Is there any reason you can't save the workbook as a macro enabled workbook? What version of Excel are you using? Ken "Eric" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to skip confirmation for macro and update all links?
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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Eric" wrote: 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 "Ken Warthen" wrote: Eric, Is there any reason you can't save the workbook as a macro enabled workbook? What version of Excel are you using? Ken "Eric" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to skip confirmation for macro and update all links?
See "Enable Macros to Run" in the Excel Help file.
"Eric" wrote in message ... 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 "Ken Warthen" wrote: Eric, Is there any reason you can't save the workbook as a macro enabled workbook? What version of Excel are you using? Ken "Eric" wrote: 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to skip confirmation for macro and update all links?
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 "Shane Devenshire" wrote: 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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Eric" wrote: 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 "Ken Warthen" wrote: Eric, Is there any reason you can't save the workbook as a macro enabled workbook? What version of Excel are you using? Ken "Eric" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to skip the enable update confirmation? | Excel Discussion (Misc queries) | |||
Using Macro to update Links | Excel Programming | |||
macro for update links | Excel Programming | |||
Update links macro | Excel Programming | |||
how to skip Update Values dialog when links change tonon-existent spreadsheets? | Excel Programming |