-
By 'rules' do you mean code?
In this scenario I have generally said that trying to circumvent enterprise security probably isn't my job, but I'm happy to help if someone can get that done for me, or supply the source by other means.
-
Can you edit vba?
You need to enable developer mode I think, then open the vba window then Look at the code -
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'.
You are reading a single comment by @hugo7 and its replies.
Click here to read the full conversation.
chez_jay
Chalfie
peter_h
@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