What code do I need to ensure that when I open a spreadsheet macros are
automatically enabled in security rather than the programme giving the
option via the security tab?

I suppose it can't be done otherwise it could be exploited maliciously?

Mark