Johnny C
Well-known Member
- Joined
- Nov 7, 2006
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
I expect this won't be possible but it's worth an ask.
All my workbooks have macros, and I might be opening them at the rate of 1 per minute for a couple of days to run things. to stop Excel getting it's knickers in a twist I need to restart XL regularly.
I run a sort of network-based version, most of the code is on my PC but a lot of options are overlaid from the network when I start XL. Oneof which is Security level.
I can go into Tools>Options>Security>Macro security and reset it to Low each time but it's a hassle each time I open Excel and I'd rather put it into my personal.xls!ThisWorkbook tab as a piece of VBA.
Is this possible? I suspect not or rogue spreadsheets could in theory reset the level prior to another more malicious workbook being opened, but as I said it's worth an ask.
All my workbooks have macros, and I might be opening them at the rate of 1 per minute for a couple of days to run things. to stop Excel getting it's knickers in a twist I need to restart XL regularly.
I run a sort of network-based version, most of the code is on my PC but a lot of options are overlaid from the network when I start XL. Oneof which is Security level.
I can go into Tools>Options>Security>Macro security and reset it to Low each time but it's a hassle each time I open Excel and I'd rather put it into my personal.xls!ThisWorkbook tab as a piece of VBA.
Is this possible? I suspect not or rogue spreadsheets could in theory reset the level prior to another more malicious workbook being opened, but as I said it's worth an ask.