I have a spreadsheet that has macros contained and linked
sheets within. I wish to write code to accept the fact it
has macros and the linked sheets, i.e. Answering yes to
enable macros and yes to linking the sheets, can anyone
advise how to do this?

TIA

Nath.

Hi
if you want this kind of code within your workbook: not possible
(otherwise you could circumvent this security feature). You may set the
security level to 'Low'. But be sure you are aware of the risk
involved!

--
Regards
Frank Kabel
Frankfurt, Germany


Nath wrote:
I have a spreadsheet that has macros contained and linked
sheets within. I wish to write code to accept the fact it
has macros and the linked sheets, i.e. Answering yes to
enable macros and yes to linking the sheets, can anyone
advise how to do this?

TIA

Nath.