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.