applying macro to startup

[David Webster]

Hello

I created a code in a module that allows me to map Paste Special Value to
F15. I want this macro to automatically start when I load any new workbook,
how do I do this?

Thanks
David

 

[Peo Sjoblom]

Press Alt + F11, open help and look for

WorkbookOpen event

 

[Bob Phillips]

David,

Put the code in a macro called Auto_Open, or in the Workbook_Open event code
in ThisWorbkbook code module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)