View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default Can I create a button for a formula?

yes. when you open the VBA editor to work on your macro, you'll see
two projects, the workbook you're in and another named PERSONAL.XLS.
(if you don't see personal.xls, record some simple macro & tell it you
want it to store in personal.xls, and it will create one. you can
always remove the recorded macro later.)

add a module to personal.xls. copy & paste the pertinent macro that
you already have to personal.xls's new module. now, out in excel,
right click in the toolbars and add a custom button (choose
"Customize", "Commands", "Macros", "Custom Button").
drag the custom button to where you want it on a toolbar. right click
the custom button & assign macro. choose the personal.xls version of
the macro.

now EXIT excel and save your personal.xls (it will ask you). when you
re-open, the button will be there & will run that macro anytime you
push it.
hope this helps.
:)
susan



On May 19, 3:35*pm, Kristi_ut
wrote:
I have a formula that I use several times a day in various workbooks. *The
formula is always =(I2&" "&J2) written in Cell K2. *I created a macro, but it
keeps tying to the workbook. *I want to create a button that will automaticly
type this formula no matter the workbook I'm in. *Is this possible?