ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   trusted source/publisher (https://www.excelbanter.com/excel-programming/322713-trusted-source-publisher.html)

Bert[_2_]

trusted source/publisher
 
I've created a calendaring spreadsheet for an organization. The workbook I
created includes some macros. I created it on my own system using Excel
2003. Now I've loaded it onto the organization's computer running Excel
2000 (I think). The spreadsheet and macros work fine, except now when it
loads, the user is prompted with the enable/disable macros dialog on
startup. I don't want to change the basic security settings in Excel, which
I think would allow the workbook to load without this prompt, but so would
any other spreadsheets with less "trustworthy" macros. (In my own copy of
Excel 2003, I'm listed as a trusted publisher.) In Excel 2000, I understand
they use the term "trusted source", but is there an easy way (or any way)
for the macros in this workbook to be loaded without the prompt?
Thanks.
Bert




All times are GMT +1. The time now is 11:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com