Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 12
Default how do i build user defined toolbar and custom button in xl07

i have a number of custom toolbars for my own macro buttons in excel 2003.
how can i transfer these to excel 2007, or build then from srratch. i need to
make custom buttons for delineation of the different uses.
--
jwm
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 96
Default how do i build user defined toolbar and custom button in xl07

You can customise the quick access toolbar - it defaults to the top left -
move it to below the ribbon if you like. Click the down arrow - more
commands - down arrow to show menu in chose commands from - default is
popular commands - select macros - that should show you what you can select
and add to your toolbar

"velvetlady" wrote:

i have a number of custom toolbars for my own macro buttons in excel 2003.
how can i transfer these to excel 2007, or build then from srratch. i need to
make custom buttons for delineation of the different uses.
--
jwm

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 12
Default how do i build user defined toolbar and custom button in xl07

I am a new user to EXCEL 2007 but have been using EXCEL for years. I use XL
2003 now. My problem is that I have 9 user defined toolbars with about 85
macros invloved. The individual buttons were built to describe what each one
does. I use these extensively. I there a way to "move" or recreate, if I
must, the macro buttons and toolbars in EXCEL 2007? If not I may as well stay
with 2003.
Thanks for your reply,
jwm


"Arceedee" wrote:

You can customise the quick access toolbar - it defaults to the top left -
move it to below the ribbon if you like. Click the down arrow - more
commands - down arrow to show menu in chose commands from - default is
popular commands - select macros - that should show you what you can select
and add to your toolbar

"velvetlady" wrote:

i have a number of custom toolbars for my own macro buttons in excel 2003.
how can i transfer these to excel 2007, or build then from srratch. i need to
make custom buttons for delineation of the different uses.
--
jwm

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,344
Default how do i build user defined toolbar and custom button in xl07

Hi,

Any custom toolbars you had created in 2003 will appear as a separate group
on the add-ins tab. If you don't like this, the only alternative you have is
to do ribbon customisation. Or, I understand there are add-ins to allow the
2007 to have the "Classic" look and feel. I haven't seen one of these in
operation so i can verify or vouch for it.

I googled this and found a lot of listings: "classic menus for Excel 2007"

If this helps, please click the Yes button.

--
Thanks,
Shane Devenshire


"Arceedee" wrote:

You can customise the quick access toolbar - it defaults to the top left -
move it to below the ribbon if you like. Click the down arrow - more
commands - down arrow to show menu in chose commands from - default is
popular commands - select macros - that should show you what you can select
and add to your toolbar

"velvetlady" wrote:

i have a number of custom toolbars for my own macro buttons in excel 2003.
how can i transfer these to excel 2007, or build then from srratch. i need to
make custom buttons for delineation of the different uses.
--
jwm

  #5   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,123
Default how do i build user defined toolbar and custom button in xl07

Maybe you like this menu
http://www.rondebruin.nl/qat.htm

See also the other 2007 pages on my site


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"velvetlady" wrote in message ...
I am a new user to EXCEL 2007 but have been using EXCEL for years. I use XL
2003 now. My problem is that I have 9 user defined toolbars with about 85
macros invloved. The individual buttons were built to describe what each one
does. I use these extensively. I there a way to "move" or recreate, if I
must, the macro buttons and toolbars in EXCEL 2007? If not I may as well stay
with 2003.
Thanks for your reply,
jwm


"Arceedee" wrote:

You can customise the quick access toolbar - it defaults to the top left -
move it to below the ribbon if you like. Click the down arrow - more
commands - down arrow to show menu in chose commands from - default is
popular commands - select macros - that should show you what you can select
and add to your toolbar

"velvetlady" wrote:

i have a number of custom toolbars for my own macro buttons in excel 2003.
how can i transfer these to excel 2007, or build then from srratch. i need to
make custom buttons for delineation of the different uses.
--
jwm



  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default how do i build user defined toolbar and custom button in xl07


"ShaneDevenshire" wrote in
message ...
Hi,

Any custom toolbars you had created in 2003 will appear as a separate
group
on the add-ins tab. If you don't like this, the only alternative you have
is
to do ribbon customisation. Or, I understand there are add-ins to allow
the
2007 to have the "Classic" look and feel. I haven't seen one of these in
operation so i can verify or vouch for it.

I googled this and found a lot of listings: "classic menus for Excel
2007"

If this helps, please click the Yes button.

--
Thanks,
Shane Devenshire


"Arceedee" wrote:

You can customise the quick access toolbar - it defaults to the top
left -
move it to below the ribbon if you like. Click the down arrow - more
commands - down arrow to show menu in chose commands from - default is
popular commands - select macros - that should show you what you can
select
and add to your toolbar

"velvetlady" wrote:

i have a number of custom toolbars for my own macro buttons in excel
2003.
how can i transfer these to excel 2007, or build then from srratch. i
need to
make custom buttons for delineation of the different uses.
--
jwm



Hi,

I tried "classic menus for Excel 2007", but you only get the Standard &
Formatting toolbars and you cannot add or remove your own customisations to
them.

The Office 2007 Ribbon (pardon me while I puke) is the reason I am sticking
with Office 2003.


--
Kind Regards
Michael Doncaster
http://www.english-hiker.myby.co.uk


  #7   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 8
Default how do i build user defined toolbar and custom button in xl07

I have several operations I change as an example changing the movement
direction
alternating between Down and Right. I have a macro that toggles those
commands and put it on my Quick Access tool bar by Using the Customize More
Commands then selecting Macro's in Chose Commands and all the Macro's I have
in Personal 2007 and my also copied in my 2003 Personal macros. Some of my
2003 macros had to be modified to work in 2007 but they are available for me
to use.

Another way of doing large amounts is to create a form in Personal.xksb
using an option box and the Select Case statements to do larger amounts of
special macro's then call the form in a macro to add to the Quick Access
toolbar.
--
Skip
Using Office 2003 Pro
2007 Student version


"Michael Doncaster" wrote:


"ShaneDevenshire" wrote in
message ...
Hi,

Any custom toolbars you had created in 2003 will appear as a separate
group
on the add-ins tab. If you don't like this, the only alternative you have
is
to do ribbon customisation. Or, I understand there are add-ins to allow
the
2007 to have the "Classic" look and feel. I haven't seen one of these in
operation so i can verify or vouch for it.

I googled this and found a lot of listings: "classic menus for Excel
2007"

If this helps, please click the Yes button.

--
Thanks,
Shane Devenshire


"Arceedee" wrote:

You can customise the quick access toolbar - it defaults to the top
left -
move it to below the ribbon if you like. Click the down arrow - more
commands - down arrow to show menu in chose commands from - default is
popular commands - select macros - that should show you what you can
select
and add to your toolbar

"velvetlady" wrote:

i have a number of custom toolbars for my own macro buttons in excel
2003.
how can i transfer these to excel 2007, or build then from srratch. i
need to
make custom buttons for delineation of the different uses.
--
jwm



Hi,

I tried "classic menus for Excel 2007", but you only get the Standard &
Formatting toolbars and you cannot add or remove your own customisations to
them.

The Office 2007 Ribbon (pardon me while I puke) is the reason I am sticking
with Office 2003.


--
Kind Regards
Michael Doncaster
http://www.english-hiker.myby.co.uk



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Format for User Defined Function [email protected] Excel Discussion (Misc queries) 5 August 7th 06 11:27 PM
Setting up a Custom type, User-defined, Default Chart Kurt Charts and Charting in Excel 0 December 22nd 05 08:43 PM
User Defined/Custom Input Bonnie. Excel Discussion (Misc queries) 2 October 14th 05 09:04 AM
User-defined (Custom) Charts BHARATH RAJAMANI Charts and Charting in Excel 1 August 23rd 05 08:43 AM
Attaching a particular user defined function to cust button Ajay Excel Discussion (Misc queries) 3 February 23rd 05 09:29 AM


All times are GMT +1. The time now is 12:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"