-
Is there a way I can open the file in some sort of readonly or text version to see the rules?
This sounds like something I see at work if I download an xlsm file. To get round it, I right click on the file and go to 'properties'. In the 'attributes' section on the general tab, there's a 'security' section and a tick box on the right that's labelled something like 'unblock'. I tick the box and click 'ok'. Then I can run the macros.
To view the macros in the file after this, open the file, go to 'view' and 'macros'.
peter_h-
This sounds like something I see at work if I download an xlsm file. To get round it, I right click on the file and go to 'properties'. In the 'attributes' section on the general tab, there's a 'security' section and a tick box on the right that's labelled something like 'unblock'. I tick the box and click 'ok'. Then I can run the macros.
To view the macros in the file after this, open the file, go to 'view' and 'macros'.
This plus quickly hitting alt+f11 seems to have worked.
- right click
- properties
- general tab
- security: Unblock
- apply
- right click
chez_jay
hugo7
I have a set of xlsm files that I want to see the rules for so I don't have to manually gather them from the people who originated the file - assuming that person(s) exists.
Changing the macro settings in the trust center does nothing.
Is there a way I can open the file in some sort of readonly or text version to see the rules?
Cheers