Macro to load on open
I was just wanting the macro to be there whenever I opened excel - i.e. if I
opened an excel file from you, I'd like to be able to run this code on it.
I've looked in the XLStart folder on my hard drive - it appears to be empty,
even with "hide" turned off.
Could this be loaded from elsewhere? Or do I need to take a worksheet and
save it to there as personal.xls?
Steve
"Tom Ogilvy" wrote in message
...
If you just mean you need the macro available, you can place it in your
personal.xls
if you want it triggered by performing a download, that wouldn't be as
straightforward.
--
Regards,
Tom Ogilvy
"Steve Chatham" wrote in message
...
Is there a way to have the default workbook to open a macro?
What I am wanting to do is to make a change to Excel that would load a
macro
to delete hyperlinks (cells.hyperlinks.delete) that'd load when I opened
excel, so all I'd have to do after pasting a web page into excel is to
run
that macro.
Have not found a way to do this without a lot of trouble, and would need
to
have a method of letting less-than-expert users be able to do this
easily.
I was thinking that making excel load this macro on open would be the
best
way to do it.
SC
|