My macro setting are set to disable with notification. If I open a file from email it asks me the first time, but if I save and then reopen it, it doesn't ask the next time. To get it to show the enable macro security ribbon again I have to send it in an email again. Can anyone tell me why the security doesn't work everytime I open the file?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
macro security setting
- Thread starter Macklin
- Start date
Ruddles
Well-known Member
- Joined
- Aug 24, 2010
- Messages
- 5,851
- Office Version
- 365
- Platform
- Windows
Maybe because the security applies to the location you're opening the file from and not the file itself.
Are you saving it to a trusted location? If so, it would open from there without any warnings.
Are you saving it to a trusted location? If so, it would open from there without any warnings.
Upvote
0
