Macros Help

S

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
 
D

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.
 
Top