Macros Help

[Str8]

For some reason my marcos keep disapearing. I need to go click on my
personal.xls then they're available, but as soon as I close excel, then
reopen, their gone and I have to go click on the personal.xls file again.
I know I've had this issue before but seems like I just hid that file and
all was good this time it doesn't seem to be working.
Any ideas?

Thanks

[Dave Peterson]

Make sure you're putting personal.xls in a folder that excel will inspect when
it starts.

I like to find that folder this way:

Open excel
hit alt-f8 (to get to the VBE)
hit ctrl-g (to see the immediate window)

type this and hit enter:
?application.startuppath

Make a note of it and store your personal.xls in that folder.



Str8 wrote:
>
> For some reason my marcos keep disapearing. I need to go click on my
> personal.xls then they're available, but as soon as I close excel, then
> reopen, their gone and I have to go click on the personal.xls file again.
> I know I've had this issue before but seems like I just hid that file and
> all was good this time it doesn't seem to be working.
> Any ideas?
>
> Thanks

--

Dave Peterson