The only way to get Excel past the Macro Warning

[Duong gia]

The only way to get Excel past the Macro Warning, is to put code in one of the files in the XLStart directory, or in the Alternate Startup File Location (Can be seen & set under Tools/Options/Tab General). Any file outside those two locations will be subject to the Macro Warning Dialog, if set by the user. The method Ahammar mentions will also work, that is, call the file from your personal.xls file. Another method, more generally useful, would be to distribute your file with an installer, which would be a very simple executable .bat which copies the file to the right directory. To make the .bat, just open notepad, enter these three lines: Copy "dummy97.xls" "C:\Program Files\Microsoft Office\Office\Xlstart" Erase "dummy97.xls" Erase "Install.bat" and save the file to Install.bat When sending your application, give instructions, to put all files sent in a temporary directory, and to run install.bat The .bat file will take care of saving file to correct directory, and will delete all traces of the temporary directory. Good Luck (Trích từ mạng Internet, gửi các bạn ngcứu)