Prev: Where is the number lock key on my HP Pavilion zv 6000????????
Next: formula for moving information from one sheet to another sheet
From: BG Mark on 5 Jun 2010 12:44 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.
From: BG Mark on 5 Jun 2010 12:44 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/archive/2010/03/27/deploy-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 > . >
From: BG Mark on 5 Jun 2010 12:44
A late reply but many thanks "Gord Dibben" wrote: > Excel 2003 > > Tools>Customize>Commands>Macros > > 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 > <BGMark(a)discussions.microsoft.com> 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. > > . > |