tool bar button

[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

 

[Gord Dibben]

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

 

[Vsn]

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

 

[Gord Dibben]

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