A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Save a macro button onto a toolbar



 
 
Thread Tools Display Modes
  #1  
Old April 8th, 2010, 10:05 AM posted to microsoft.public.excel.misc
BG Mark
external usenet poster
 
Posts: 16
Default Save a macro button onto a toolbar

I have cerated a macro button in a spreadsheet, and I would like to know if
it is possible to save that button onto a toollbar so that I can use it on
any spreadsheet.
  #2  
Old April 8th, 2010, 10:19 AM posted to microsoft.public.excel.misc
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default Save a macro button onto a toolbar

EXCEL 2007

Try this:-

1. Office Button (top left hand corner).

2. Excel Options (lower right hand corner).

3. Customize.

On the right hand side in here there is a section called:-

Choose commands from:

Click on the drop down arrow and select Macros.

4. A list of available Macros should appear on the left hand side.

Click the one that you want then click on the Add button.

5. Your Macro should now appear on the right hand side.

6. You can move its position on the Quick Access Toolbar by clicking the up
or down arrows (on the far right hand side).

7. Finally click OK.

8. Your Macro should now be assigned to the Quick Access Toolbar.

If my comments have helped please hit Yes.

Thanks.


"BG Mark" wrote:

I have cerated a macro button in a spreadsheet, and I would like to know if
it is possible to save that button onto a toollbar so that I can use it on
any spreadsheet.

  #3  
Old April 8th, 2010, 03:54 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Save a macro button onto a toolbar

Excel 2003

ToolsCustomizeCommandsMacros

Drag smiley face up to a Toolbar.

Right-click and assign macro.

Note: you can also change the Icon image and its name..


Gord Dibben MS Excel MVP

On Thu, 8 Apr 2010 02:05:01 -0700, BG Mark
wrote:

I have cerated a macro button in a spreadsheet, and I would like to know if
it is possible to save that button onto a toollbar so that I can use it on
any spreadsheet.


  #4  
Old April 8th, 2010, 04:33 PM posted to microsoft.public.excel.misc
BG Mark
external usenet poster
 
Posts: 16
Default Save a macro button onto a toolbar

Unfortunately I am using excel 2003, and cannot see the 'Office' button

"trip_to_tokyo" wrote:

EXCEL 2007

Try this:-

1. Office Button (top left hand corner).

2. Excel Options (lower right hand corner).

3. Customize.

On the right hand side in here there is a section called:-

Choose commands from:

Click on the drop down arrow and select Macros.

4. A list of available Macros should appear on the left hand side.

Click the one that you want then click on the Add button.

5. Your Macro should now appear on the right hand side.

6. You can move its position on the Quick Access Toolbar by clicking the up
or down arrows (on the far right hand side).

7. Finally click OK.

8. Your Macro should now be assigned to the Quick Access Toolbar.

If my comments have helped please hit Yes.

Thanks.


"BG Mark" wrote:

I have cerated a macro button in a spreadsheet, and I would like to know if
it is possible to save that button onto a toollbar so that I can use it on
any spreadsheet.

  #5  
Old April 8th, 2010, 04:51 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Save a macro button onto a toolbar

Saved from a previous post:

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

And Bob Phillips shows a way to use a wrapper so that it can work in both xl2003
and xl2007.
http://msmvps.com/blogs/xldynamic/ar...me-simple.aspx



BG Mark wrote:

I have cerated a macro button in a spreadsheet, and I would like to know if
it is possible to save that button onto a toollbar so that I can use it on
any spreadsheet.


--

Dave Peterson
  #6  
Old June 5th, 2010, 05:44 PM posted to microsoft.public.excel.misc
BG Mark
external usenet poster
 
Posts: 16
Default Save a macro button onto a toolbar

Belatedl but many thanks

"trip_to_tokyo" wrote:

EXCEL 2007

Try this:-

1. Office Button (top left hand corner).

2. Excel Options (lower right hand corner).

3. Customize.

On the right hand side in here there is a section called:-

Choose commands from:

Click on the drop down arrow and select Macros.

4. A list of available Macros should appear on the left hand side.

Click the one that you want then click on the Add button.

5. Your Macro should now appear on the right hand side.

6. You can move its position on the Quick Access Toolbar by clicking the up
or down arrows (on the far right hand side).

7. Finally click OK.

8. Your Macro should now be assigned to the Quick Access Toolbar.

If my comments have helped please hit Yes.

Thanks.


"BG Mark" wrote:

I have cerated a macro button in a spreadsheet, and I would like to know if
it is possible to save that button onto a toollbar so that I can use it on
any spreadsheet.

  #7  
Old June 5th, 2010, 05:44 PM posted to microsoft.public.excel.misc
BG Mark
external usenet poster
 
Posts: 16
Default Save a macro button onto a toolbar

A long overdue thank you

"Dave Peterson" wrote:

Saved from a previous post:

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

And Bob Phillips shows a way to use a wrapper so that it can work in both xl2003
and xl2007.
http://msmvps.com/blogs/xldynamic/ar...me-simple.aspx



BG Mark wrote:

I have cerated a macro button in a spreadsheet, and I would like to know if
it is possible to save that button onto a toollbar so that I can use it on
any spreadsheet.


--

Dave Peterson
.

  #8  
Old June 5th, 2010, 05:44 PM posted to microsoft.public.excel.misc
BG Mark
external usenet poster
 
Posts: 16
Default Save a macro button onto a toolbar

A late reply but many thanks

"Gord Dibben" wrote:

Excel 2003

ToolsCustomizeCommandsMacros

Drag smiley face up to a Toolbar.

Right-click and assign macro.

Note: you can also change the Icon image and its name..


Gord Dibben MS Excel MVP

On Thu, 8 Apr 2010 02:05:01 -0700, BG Mark
wrote:

I have cerated a macro button in a spreadsheet, and I would like to know if
it is possible to save that button onto a toollbar so that I can use it on
any spreadsheet.


.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:40 PM.


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