I've generated a macro (MyPi) in my personal workbook (as you described earlier) but when I try to access it from another workbook I get the message "Sub or Function not defined." The statement in the other workbook is "MyPi Pi" since MyPi has one argument. Is there something else I must to to make MyPi accessible in another workbook besides storing it in PERSONAL? Thanks

----- Bob Phillips wrote: ----

Bram

Not sure what more I can explain, but here goes

Personal.xls is at is says a personal workbook, where you can store thing
just for your Excel implementation. It is special in that when Excel starts
Personal.xls is automatically opened, and is hidden. It is normally store
in the XLStart directory, which differs from OS to OS. If you record
macro, you will be given an option to store it in Personal.xls. This is
good way to create that workbook as it doesn't exist by default, and you ca
delete the macro afterwards

Anything else I can tell you

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

"bramweisman " wrote in messag
..
Hi, Bob
Thanks for the tip. I've successfully implemented the "add-in" scheme
But I wanted to fully understand the Personal.xls approach. I trie
that, but it didn't seem to help a new workbook
Can you explain a bit more
Thanks again
Bra
--
Message posted from http://www.ExcelForum.com