Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating Custom Commands on a Toolbar
When I have tried creating a custom command by recording a macro., the
command just performs the macro on the cell that I used to record the macro, but I would like it to be on the toolbar no matter what excel book I open and perform the command on the specific cell or text that I select, not the cell that I used to create the Macro. Can someone walk me though the exact steps to do this without having to enter a code? Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating Custom Commands on a Toolbar
You can use ActiveCell instead of Range("A1") in your code.
Or ActiveSheet or ActiveWorkbook Store your macro(s) in your Personal.xls workbook and they will be available for all open workbooks. For a button available for all workbooks go to ToolsCustomizeCommandsMacros Drag the smiley face button up to a Toolbar and assign the macro to that button. Best however if your Personal.xls creates the Toolbar and the buttons. See Dabra Dalgleish's site for more on creating Toolbars, but it does involve entering code. http://www.contextures.on.ca/xlToolbar02.html Gord Dibben MS Excel MVP On Mon, 19 Nov 2007 10:00:01 -0800, rllngriver wrote: When I have tried creating a custom command by recording a macro., the command just performs the macro on the cell that I used to record the macro, but I would like it to be on the toolbar no matter what excel book I open and perform the command on the specific cell or text that I select, not the cell that I used to create the Macro. Can someone walk me though the exact steps to do this without having to enter a code? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use MS Word commands in an MS Excel toolbar? | Setting up and Configuration of Excel | |||
Excel toolbar commands | Excel Worksheet Functions | |||
How to deploy custome toolbar/Menu commands in Excel? | Excel Worksheet Functions | |||
Toolbar commands | Excel Discussion (Misc queries) | |||
Why are some commands in Excel's Drawing Toolbar greyed-out (eg T. | Excel Discussion (Misc queries) |