question

RefToHyp-0660 avatar image
0 Votes"
RefToHyp-0660 asked ·

Macros vs Trust Center Settings

Safety mechanism of Office is so misterious for me. I created macros for MS Word, save them in normal.dotm. In the Trust Center I set:

  • Disable all macros with notifications

  • unchecked Trust access to the VBA procject..

Every my macros works fine. I sent my macros to my friend. She imported macros and saved them as a template normal.dotm also and set the same settings in the Trust Center as I did. She has got a massege "The macro cannot be found or has been disabled because of your Macro security settings" Why is that? I would like to avoid the situation when using my macro by other person requires potential dangerous setting in a Trust Center as "Enable all macros...."



office-vba-devoffice-word-itpro
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

0 Votes 0 ·
JohnKorchok avatar image
0 Votes"
JohnKorchok answered ·

The settings are doing exactly what they are supposed to, disabling the macro with a notification. Most likely they have the default Protected View options checked. They should open File>Options>Trust Center>Trust Center Settings>Protected View and uncheck all three options.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PM-9915 avatar image
0 Votes"
PM-9915 answered ·

Yes, it seems to work. Disabling protected view fixed this problem

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.