You are reading a single comment by @hugo7 and its replies.
Click here to read the full conversation.
-
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
hugo7
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'.