Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application Level Events | Excel Programming | |||
Application level event help | Excel Discussion (Misc queries) | |||
Application level VBE | Excel Programming | |||
Application Level macros | Excel Programming | |||
Declare at application level | Excel Programming |