tool bar button

  • Thread starter Thread starter Vsn
  • Start date Start date
V

Vsn

Hi all,

Could someone tell me how I could assign a function which is loaded with an
add-in (*.xla) to a tool bar button. The function is to paste a date-time
stamp value. The idea is that the function will be always available, via the
tool bar button, in any workbook I do open.

I cant figure out how to do this, while in Word it is quit simple via the
"Normal.dot" template.


Thx, for any help on this one.

Ludovic
 
Here is the macro.

Sub NOWTIME()
ActiveCell.Value = Format(Now(), "dd mmm yyyy h:mm:ss AM/PM")
End Sub

Store it in a module in a new workbook.

Assign it to a toolbar button which you get from Tools>Customize>Commands>Macros

Save the workbook as an add-in stored in Office\Libray folder.

Load the add-in through Tools>Add-ins and it will open each time Excel is
started.

NOTE: a static date/time can be entered by this method without a macro.........

CTRL + ;<space>CTRL + SHIFT + ;


Gord Dibben MS Excel MVP
 
Gord,

Thx for below advice it works fine.

I was however wondering if I could do it without the workbook? I mean having
the Macro in an module which sits in a XLA file?

Thx,
Ludovic
 
Re-read my original post.

That post gave instructions on how to place the macro in a new workbook which
you save as an add-in(*.xla)

Add-ins are nothing more than workbooks that have been saved as an *.xla file.

File>Save As>File Type>MS Excel Add-in(*.xla)


Gord
 
Back
Top