Enable macros not working in shared environment.

[milo1984]

Hi There,

I have the age old problem where I have a workbook full of macros and Active X controls which used to work and now is not working properly.

There are hundreds of people who access a template from a shared link on our Corporate network. Now, when they access it, it does not request 'enable macros', but if they access it on their local desktop, it asks them to enable macros.

I am on the corporate network, and can access all the macros, but it doesn't prompt me to enable macros.

I made some changes to the protection of the document mainly the following:

Please Login or Register  to view this content.

up until last Thursday, everyone could access it without issue. now, no matter what I try, it does not ask to enable macros and no one can access the functionality.

any help you could provide would be gratefully received.

Unfortunately, I cannot share the template due to sensitivity.

Many thanks in advance.

[milo1984]

Hi, is there any feedback on this?

I have got to a stage where it requests to 'enable macros', but even if they say 'yes', nothing happens.

any ideas would be very gratefully received. it is driving me mad.

Thanks in advance.

[shirleyxls]

Not sure what is happening but feel your pain!
Did you check with your IT support department to see if they have implemented any new patches or something in their security software to prevent people running xlsm files?
Are you able to restore a version from when it was working (prior to last Thursday) and try it again? I know the data will be out of date by now, but at least it could narrow down the problem to see if it's your workbook or something else which is causing it.