Forum Discussion
Unable to make macro enabled workbook a Trusted Document because of Microsoft Excel Security Notice
I've been making Macros for excel for a few years. I recently make 2 workbooks with macros for a couple of departments at work. I made a 3rd macro workbook that opens the other 2 as read-only to pu...
Try the following (each user will have to do this):
- Select File > Options > Trust Center > Trust Center Settings... > Trusted Locations.
- Tick the check box 'Allow trusted locations on my network (not recommended)'.
- Click 'Add new location...'
- Add the folder containing the macro workbook as a trusted location.
- OK your way out.
- I appreciate the response, however this is not an option for me. I am not an admin for our network and there is next to zero chance the admins will be willing to change the network security setting just to make my project less of a bother to use. Do you know if there is a way to trust a specific document when the Security Notice shows up instead of a location?
Sorry, no.
- At least I know now. Thanks for your time.
