Macro to load on open
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
|