Home > IT Answers > Development > Existing macros attached to custom toolbar buttons
Tad957
5 pts.
 Existing macros attached to custom toolbar buttons
Application development, Excel 2007 macros, Excel Custom Views, Excel Toolbars
I have an Excel spreadsheet that contains several macros that are attached to custom buttons on a custom toolbar. When I open this spreadsheet in Excel 2007 none of the macros are attached to the buttons, how can I attach these macros to the correct buttons. Can I have this toolbar showing at the same time as another toolbar like I could in previous versions of Excel?

Software/Hardware used:
Excel 2007
ASKED: July 12, 2010  7:47 PM
UPDATED: December 1, 2010  10:14 AM
RELATED QUESTIONS
Answer Wiki:
Just try out this to solve .... 1. Click Trust Center > Trust Center Settings > Macro Settings Now set the options as u desire..... Disable all macros without notification Disable all macros with notification Disable all macros except digitally signed macros Enable all macros Trust access to the VBA project object model Remember these r the default options. Or u have to convert the macros. for more info link to this : http://social.msdn.microsoft.com/Forums/en/innovateonoffice/thread/26afb4f2-a123-476c-af99-b2970c6c86a7
Last Wiki Answer Submitted:  December 1, 2010  10:14 am  by  Subhendu Sen   22,035 pts.
All Answer Wiki Contributors:  Subhendu Sen   22,035 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _