Hello Peter,
In vba help look for the "assistant object".
One line in there says:
"The default Assistant is Rocky.
To select a different Assistant programmatically,
use the FileName property."
I provide no example as I have never used it.
Regards,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"Peter Rooney"
wrote in message
Good afternoon, all.
I realise that the Assistant is part of Office and not Excel, so (I think) I
understand why, when I record myself changing the assistant, nothing is
recorded.
The question is, of course, how DO I code a change of Assistant?
Thanks in advance
Pete