Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning Macros in Excel 2007
I'm a new user to Excel 2007. I've imported templates from Excel 2000/2003.
These use personalised toolbars incorporating created buttons and assigned macros. In Excel 2007, I see that the toolbar is shown in the Add-in tab. Standard buttons e.g print preview etc work OK but the specialized ones are looking for the macros. How do I assign macros to th buttons in the Add-in tab toolbar?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning Macros in Excel 2007
If these buttons are either shapes (as a text box) or a button from the Forms
toolbox, then you should be able to right-click it and choose [Assign Macro] just as you did in earlier versions of Excel. However, if the macros are defined as "Private" they won't show up in the list of macros available for assignment and easiest thing to do is probably to go into the VB Editor ([Alt]+[F11]) and find them and remove the word "Private " from their Private Sub MacroName() line, assign the macros and go beck into the VBE and put Private back onto the macro names to keep them hidden from the list of macros available for direct use. Hope this helps. If they're buttons from the ActiveX Controls Toolbox, things are a little different. "barrowhill" wrote: I'm a new user to Excel 2007. I've imported templates from Excel 2000/2003. These use personalised toolbars incorporating created buttons and assigned macros. In Excel 2007, I see that the toolbar is shown in the Add-in tab. Standard buttons e.g print preview etc work OK but the specialized ones are looking for the macros. How do I assign macros to th buttons in the Add-in tab toolbar?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning RMS permissions in Excel 2007 | Excel Discussion (Misc queries) | |||
Assigning Macros | Excel Worksheet Functions | |||
Assigning macros | Excel Discussion (Misc queries) | |||
assigning macros | Excel Discussion (Misc queries) | |||
Assigning Macros to Buttons in Excel | Excel Worksheet Functions |