Hi
I would create an addin (*.xla file) and install this

--
Regards
Frank Kabel
Frankfurt, Germany

"ELVIS ARON PRESLEY" <ELVIS ARON
schrieb im Newsbeitrag
...
for example: i have a macro set and working in workbook #a when
needed .
can i run this macro in work book #a when the book is closed.
can i run this macro from another open workbook.i know you can copy
macro to
other books, i do not want that. i want to opoerate the macro in work
book
"A" from a remote location [example : another work book] while work
book #2
is closed or open [what ever]