Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 vb scripts and toolbars in 2007
With the help of many of you I have managed to put together a great tool for
my job. Most of the tool relies on custom menus with scripts written (or recorded) in Excel 2003. Now that I am using 2007 I do not see the same menus (for obvious reasons). I was wondering if there was a way (by add-in or whichever) that the menu bars can appear as the did in 2003 in the 2007 version. Sort of classic view for an XP desktop. Otherwise I may have to resort to using 2003 which I am not too happy about. Thankyou oh wise ones, G |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 vb scripts and toolbars in 2007
Hi Mr BT
You can try this to make your menus on the ribbon or use the examples that use the old commandbars to create a menu that you can call in the QAT See http://www.rondebruin.nl/ribbon.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mr BT" wrote in message news:_ZGPh.11057$aG1.484@pd7urf3no... With the help of many of you I have managed to put together a great tool for my job. Most of the tool relies on custom menus with scripts written (or recorded) in Excel 2003. Now that I am using 2007 I do not see the same menus (for obvious reasons). I was wondering if there was a way (by add-in or whichever) that the menu bars can appear as the did in 2003 in the 2007 version. Sort of classic view for an XP desktop. Otherwise I may have to resort to using 2003 which I am not too happy about. Thankyou oh wise ones, G |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 vb scripts and toolbars in 2007
Unfortunately 2007 does not support a classic view.
You can create custom ribbon tabs and groups though similar to the custom commandbars you create in 2003. Ron gave you a link in his response. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mr BT" wrote in message news:_ZGPh.11057$aG1.484@pd7urf3no... With the help of many of you I have managed to put together a great tool for my job. Most of the tool relies on custom menus with scripts written (or recorded) in Excel 2003. Now that I am using 2007 I do not see the same menus (for obvious reasons). I was wondering if there was a way (by add-in or whichever) that the menu bars can appear as the did in 2003 in the 2007 version. Sort of classic view for an XP desktop. Otherwise I may have to resort to using 2003 which I am not too happy about. Thankyou oh wise ones, G |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 vb scripts and toolbars in 2007
Have you try this one Bob ?
http://addintools.com/ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob Phillips" wrote in message ... Unfortunately 2007 does not support a classic view. You can create custom ribbon tabs and groups though similar to the custom commandbars you create in 2003. Ron gave you a link in his response. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mr BT" wrote in message news:_ZGPh.11057$aG1.484@pd7urf3no... With the help of many of you I have managed to put together a great tool for my job. Most of the tool relies on custom menus with scripts written (or recorded) in Excel 2003. Now that I am using 2007 I do not see the same menus (for obvious reasons). I was wondering if there was a way (by add-in or whichever) that the menu bars can appear as the did in 2003 in the 2007 version. Sort of classic view for an XP desktop. Otherwise I may have to resort to using 2003 which I am not too happy about. Thankyou oh wise ones, G |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 vb scripts and toolbars in 2007
I have seen that before Ron (and I believe there is another which escape me
at present), but haven't tried it, must give it a try. I was correct in saying that 2007 doesn't support it though <BG. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ron de Bruin" wrote in message ... Have you try this one Bob ? http://addintools.com/ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob Phillips" wrote in message ... Unfortunately 2007 does not support a classic view. You can create custom ribbon tabs and groups though similar to the custom commandbars you create in 2003. Ron gave you a link in his response. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mr BT" wrote in message news:_ZGPh.11057$aG1.484@pd7urf3no... With the help of many of you I have managed to put together a great tool for my job. Most of the tool relies on custom menus with scripts written (or recorded) in Excel 2003. Now that I am using 2007 I do not see the same menus (for obvious reasons). I was wondering if there was a way (by add-in or whichever) that the menu bars can appear as the did in 2003 in the 2007 version. Sort of classic view for an XP desktop. Otherwise I may have to resort to using 2003 which I am not too happy about. Thankyou oh wise ones, G |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 vb scripts and toolbars in 2007
Hi Bob
but haven't tried it, must give it a try Same for me (no time now, learning Expression Web now) But I think we must look futher and not backand forget about the old way in 2007 and up I was correct in saying that 2007 doesn't support it though <BG. Yep <g -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob Phillips" wrote in message ... I have seen that before Ron (and I believe there is another which escape me at present), but haven't tried it, must give it a try. I was correct in saying that 2007 doesn't support it though <BG. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ron de Bruin" wrote in message ... Have you try this one Bob ? http://addintools.com/ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob Phillips" wrote in message ... Unfortunately 2007 does not support a classic view. You can create custom ribbon tabs and groups though similar to the custom commandbars you create in 2003. Ron gave you a link in his response. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mr BT" wrote in message news:_ZGPh.11057$aG1.484@pd7urf3no... With the help of many of you I have managed to put together a great tool for my job. Most of the tool relies on custom menus with scripts written (or recorded) in Excel 2003. Now that I am using 2007 I do not see the same menus (for obvious reasons). I was wondering if there was a way (by add-in or whichever) that the menu bars can appear as the did in 2003 in the 2007 version. Sort of classic view for an XP desktop. Otherwise I may have to resort to using 2003 which I am not too happy about. Thankyou oh wise ones, G |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 vb scripts and toolbars in 2007
Both of you guys are awesome. Exactly what I was looking for.
Thanks, G "Ron de Bruin" wrote in message ... Hi Bob but haven't tried it, must give it a try Same for me (no time now, learning Expression Web now) But I think we must look futher and not backand forget about the old way in 2007 and up I was correct in saying that 2007 doesn't support it though <BG. Yep <g -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob Phillips" wrote in message ... I have seen that before Ron (and I believe there is another which escape me at present), but haven't tried it, must give it a try. I was correct in saying that 2007 doesn't support it though <BG. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ron de Bruin" wrote in message ... Have you try this one Bob ? http://addintools.com/ -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bob Phillips" wrote in message ... Unfortunately 2007 does not support a classic view. You can create custom ribbon tabs and groups though similar to the custom commandbars you create in 2003. Ron gave you a link in his response. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mr BT" wrote in message news:_ZGPh.11057$aG1.484@pd7urf3no... With the help of many of you I have managed to put together a great tool for my job. Most of the tool relies on custom menus with scripts written (or recorded) in Excel 2003. Now that I am using 2007 I do not see the same menus (for obvious reasons). I was wondering if there was a way (by add-in or whichever) that the menu bars can appear as the did in 2003 in the 2007 version. Sort of classic view for an XP desktop. Otherwise I may have to resort to using 2003 which I am not too happy about. Thankyou oh wise ones, G |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 vb scripts and toolbars in 2007
"Ron de Bruin" wrote in message ... Hi Bob But I think we must look futher and not backand forget about the old way in 2007 and up Absolutely with you all the way there my friend. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple toolbars Etc 2007 vs. 2003 | Excel Discussion (Misc queries) | |||
Importing Excel 2003 toolbars to Excel 2007 | Excel Discussion (Misc queries) | |||
Transition from Excel 2003 to 2007 (toolbars, etc.) | Excel Discussion (Misc queries) | |||
Problem with Excel 2003 toolbars in Excel 2007 | Excel Programming | |||
Toolbars in Excel 2003 | Excel Discussion (Misc queries) |