Moving Macros to the Application Level
 

I have built a spreadsheet and written code to add a toolbar with a button
that executes a macro (that I also wrote) that formats a Scorecard
spreadsheet. As it is my team has to have my spreadsheet open, copy the
Scorecard to be formatted into my spreadsheet and then run the macro from
there. I would like to make this work without the middle-man so to speak.
Is it possible to have this code function whenever the end user opens the
spreadsheet to be formatted? In other words I want it so that when anyone on
my team opens the Scorecard spreadsheet my toolbar and macro will run
directly from the Excel the spreadsheet opens in.

Moving Macros to the Application Level
 

put the toolbar macro and the formatting macro in the Scoreboard workbook.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Bishop" wrote:

I have built a spreadsheet and written code to add a toolbar with a button
that executes a macro (that I also wrote) that formats a Scorecard
spreadsheet. As it is my team has to have my spreadsheet open, copy the
Scorecard to be formatted into my spreadsheet and then run the macro from
there. I would like to make this work without the middle-man so to speak.
Is it possible to have this code function whenever the end user opens the
spreadsheet to be formatted? In other words I want it so that when anyone on
my team opens the Scorecard spreadsheet my toolbar and macro will run
directly from the Excel the spreadsheet opens in.

Moving Macros to the Application Level
 

The Scorecard is exported from a website so there is no workbook until the
export process executes.

"Gary Brown" wrote:

put the toolbar macro and the formatting macro in the Scoreboard workbook.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Bishop" wrote:

I have built a spreadsheet and written code to add a toolbar with a button
that executes a macro (that I also wrote) that formats a Scorecard
spreadsheet. As it is my team has to have my spreadsheet open, copy the
Scorecard to be formatted into my spreadsheet and then run the macro from
there. I would like to make this work without the middle-man so to speak.
Is it possible to have this code function whenever the end user opens the
spreadsheet to be formatted? In other words I want it so that when anyone on
my team opens the Scorecard spreadsheet my toolbar and macro will run
directly from the Excel the spreadsheet opens in.