ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Moving from Excel 03 to 07, need help with customizing (https://www.excelbanter.com/excel-programming/441334-moving-excel-03-07-need-help-customizing.html)

joshua

Moving from Excel 03 to 07, need help with customizing
 
In Excel 03, we had a series of toolbars that contained buttons that ran a
macro placing a picture on the spreadsheet in the selected cell. There were
several toolbars as there were different sets of pictures in different
colors. They were used as accounting tickmarks.

I can change my macros to run on 2007 (due to 07 not liking the Select
command) but I'm having troubles finding a substitute for the custom
toolbars. The ones I had in 2003 did come over under the Add-Ins tab, but I
cannot update them as needed. Plus there is no way to bring up a toolbar for
the different color of pictures if you had it inactive in 2003.

Thank you in advance for any help!

Bob Phillips[_4_]

Moving from Excel 03 to 07, need help with customizing
 
You need to convert the toolbars to the ribbon. See
http://www.rondebruin.nl/ribbon.htm

--

HTH

Bob

"Joshua" wrote in message
...
In Excel 03, we had a series of toolbars that contained buttons that ran a
macro placing a picture on the spreadsheet in the selected cell. There
were
several toolbars as there were different sets of pictures in different
colors. They were used as accounting tickmarks.

I can change my macros to run on 2007 (due to 07 not liking the Select
command) but I'm having troubles finding a substitute for the custom
toolbars. The ones I had in 2003 did come over under the Add-Ins tab, but
I
cannot update them as needed. Plus there is no way to bring up a toolbar
for
the different color of pictures if you had it inactive in 2003.

Thank you in advance for any help!





All times are GMT +1. The time now is 07:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com