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

Answers


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.


Need Your Help

MongoMapper near with maxDistance - Mongo::OperationFailure: geo values have to be numbers:

mongodb geospatial mongomapper

I'm trying to encapsulate a near query with a maxDistance in a MongoMapper backed model.

Use border image only for bottom border? Our CSS seems to replicate the image across the whole div instead

html css css3

We would like to use an image only for the bottom of a DIV. However, our CSS somehow replicates the image across the body of the DIV instead of placing it at the bottom.