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.