ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2003 vb scripts and toolbars in 2007 (https://www.excelbanter.com/excel-programming/386625-excel-2003-vbulletin-scripts-toolbars-2007-a.html)

Mr BT

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



Ron de Bruin

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



Bob Phillips

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




Ron de Bruin

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




Bob Phillips

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




Ron de Bruin

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




Mr BT

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






Bob Phillips

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.




All times are GMT +1. The time now is 05:28 PM.

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