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