perhaps I have not understood you correctly.
But if the
vb-toolbar is avalilable in spreadsheet you click <run macro
icon you get all the macros or subs both in the hidden workbook and also in
"this workbook" you click any macro or sub in the list and click <edit you
go to that routine.
if this is not what you want apologise
PM wrote in message
...
Hello !
I know how to open Excel from VB using Automation.
I do not know how to open VB from Excel.
Is it possible, for instance, to access a Form or a routine of aVB program
?
Thank you for any advice.
And a good day to you all.
Pat.