Excel 2007 enable macros for a single excel document
Is there anyway a user can have macros enabled by default for a single workbook but not other ones? It is annoying you constantly have to enable them every time you open a particular workbook. Thanks
You can set trusted locations (folders) from which files can be opened without asking for enabling macros: http://office.microsoft.com/en-us/word-help/create-remove-or-change-a-trusted-location-for-your-files-HA010031999.aspx
In case, it is a workbook created by you then you can add your digital certificate to it. Digital certificate created by you will be trusted in your machine. Digital Certificate can be created by the tool listed in MS Office tools(start menu). And after creating digital certificate, you can attach it to your workbook in vba editor in excel.