Macro to save in every workbook

A

Adam

Hi All,

I'm fairly new to macro's in Excel ( I know it sounds mad ) but I have
created a custom toolbar where I'd like shortcuts to all my regular reports.

Now I've made a macro that opens the worksheet but when I close and reopen
Excel and try run the macro it says it cannot locate it.

Can anyone help with this please, also if theres an easier way of creating a
toolbar with excel file shortcuts in it then please also let me know.

Many Thanks
 
B

Bernie Deitrick

Adam,

I will send you an add-in that I've written that will create a commandbar
with utilities to add buttons that create a quick link to the open workbook.

Send me a message with your email address. Mine is d e i t b e @ c o n s u
m e r DOT o r g - take out the spaces and change the DOT to .

HTH,
Bernie
MS Excel MVP
 
Top