View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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