Hi i have a customer who has made an Excel spreadsheet with macros, the problem is that some users can't run the macros, if we give the user a new Windows profile on the computer in question all works fine, but now one user that has had a new user profile on her computer is experiencing the problem again, we can't continue to give users new user profiles everytime this happens, does anyone know of a solution.

Here is an example or better explanation of the problem, (User A) has a problem running Excel macros on (Computer A), (User B) can log on to (Computer A) and run macros, if (User A) gets a new Windows user profile on (Computer A) the user can run macros again.

Hope some can help.

Best regards

Richard

Hi Richard

According to your description, this issue might be due to several factors. Thus, please try check them and narrow down this issue.

1) Did user A get some error messages when ran the macros? If there are some alert messages, it would be helpful for us, please upload here.

2) Did user A's account have administrator permission? If no, please assign the administrator permission to user A, because some macros need to connect the root directory of Windows system.

3) Make sure user A has enable the security settings for VBA macros. Path: File/Option/advanced/trust center/macros.

https://technet.microsoft.com/en-us/library/ee857085.aspx?f=255&MSPPError=-2147217396

Hope it's helpful.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator 5 hours 46 minutes ago

Hi Richard

According to your description, this issue might be due to several factors. Thus, please try check them and narrow down this issue.

1) Did user A get some error messages when ran the macros? If there are some alert messages, it would be helpful for us, please upload here.

2) Did user A's account have administrator permission? If no, please assign the administrator permission to user A, because some macros need to connect the root directory of Windows system.

3) Make sure user A has enable the security settings for VBA macros. Path: File/Option/advanced/trust center/macros.

https://technet.microsoft.com/en-us/library/ee857085.aspx?f=255&MSPPError=-2147217396

Hope it's helpful.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Wednesday, May 27, 2015 1:45 AM

Hi Richard

According to your description, this issue might be due to several factors. Thus, please try check them and narrow down this issue.

1) Did user A get some error messages when ran the macros? If there are some alert messages, it would be helpful for us, please upload here.

2) Did user A's account have administrator permission? If no, please assign the administrator permission to user A, because some macros need to connect the root directory of Windows system.

3) Make sure user A has enable the security settings for VBA macros. Path: File/Option/advanced/trust center/macros.

https://technet.microsoft.com/en-us/library/ee857085.aspx?f=255&MSPPError=-2147217396

Hope it's helpful.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Edited by George.Zhao CHNMicrosoft contingent staff, Moderator Wednesday, May 27, 2015 1:45 AM

Hi George

Thanks for your quick reply.

1) No the user does not get any error or warning when opening the spreadsheet, and no error or warning when the user tries to use the macros

2) The user is local administrator on the computer

3) The stettings for VBA macros are the same on both users which kan use the macros and users that can't (i have attached a picture of the settings, even though the text is in Danish i hope you can manage)

 

Any thoughts on how to move forward.

Regards

Richard

Hi Richard,

As far as I know, if we select "Disable all macros with notification" option. Macros are disabled, but security alerts appear if there are macros present. we can enable macros on a case-by-case basis. 

Was the security alerts pop-up when user A ran the macros?

Then, please try to select the "Enable all macros (not recommended, potentially dangerous code can run) " option to test.

Regards,
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Hi Richard,

As far as I know, if we select "Disable all macros with notification" option. Macros are disabled, but security alerts appear if there are macros present. we can enable macros on a case-by-case basis. 

Was the security alerts pop-up when user A ran the macros?

Then, please try to select the "Enable all macros (not recommended, potentially dangerous code can run) " option to test.

Regards,
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator 1 hour 51 minutes ago

Hi Richard,

As far as I know, if we select "Disable all macros with notification" option. Macros are disabled, but security alerts appear if there are macros present. we can enable macros on a case-by-case basis. 

Was the security alerts pop-up when user A ran the macros?

Then, please try to select the "Enable all macros (not recommended, potentially dangerous code can run) " option to test.

Regards,
George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Tuesday, June 09, 2015 5:37 AM
• Unmarked as answer by top30 10 hours 39 minutes ago

Hi,

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

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Hi,
I'm marking the reply as answer as there has been no update for a couple of days.
If you come back to find it doesn't work for you, please reply to us and unmark the answer.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Hi

None of the suggested solutions solved the problem.

However i found a article here: External link

the last post by gm2 lead me on the right track.

Regards

Richard

• Marked as answer by top30 10 hours 39 minutes ago