Please, help me now with this
Posted by alfredo sanchez on February 23, 2001 9:02 AM
I have some vba functions that seem to work properly (at last, hehe). I would like to know if there's a way to make them available to every new workbook I open, so I can use them easily. Thanks.
Posted by Dave Hawley on February 23, 2001 9:23 AM
alfredo, Place them in your Personal macro workbook. If you dont have one yet, record a simple macro using "Personal macro workbook" under "Store macro In".
This is a hidden workbook which opens each time you open Excel. Window>Unhide.
Dave
OzGrid Business Applications
Posted by alfredo sanchez on February 24, 2001 10:13 AM
still having trouble with this: I was able to store functions in personal.xls and it worked well while XL was open, it asked me to store changes in "personal.xls" and I answered "yes". Next session, when I used my functions the value it returned is "¿#name?". I looked in VBEditor and code is still there. Please,any help with this?. Thanks.
Posted by alfredo sanchez on February 24, 2001 10:16 AM
Sorry, I didn't Thank you Dave........ Thanks!
Posted by Dave Hawley on February 24, 2001 10:35 AM
Re: Sorry, I didn't Thank you Dave........ Thanks!
alfredo, I should have said that any Custom funtions stored in the Personal workbook will need to be preceded with "PERSONAL.XLS!".
To see what I mean push Shift+F3, scroll down to User Defined Functions and you will see them.
Dave
OzGrid Business Applications
Posted by alfredo sanchez on February 24, 2001 10:41 PM
Again, Thank you Dave... Everything is OK now
