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 ToolsCustomizeCommandsMacros

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

Load the add-in through ToolsAdd-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 + ;<spaceCTRL + SHIFT + ;


Gord Dibben MS Excel MVP

On Fri, 22 Jun 2007 17:38:01 +0400, "Vsn" <vsn at hotmail wrote:

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,

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" <gorddibbATshawDOTca wrote in message
...
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
ToolsCustomizeCommandsMacros

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

Load the add-in through ToolsAdd-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 + ;<spaceCTRL + SHIFT + ;


Gord Dibben MS Excel MVP

On Fri, 22 Jun 2007 17:38:01 +0400, "Vsn" <vsn at hotmail wrote:

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

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.

FileSave AsFile TypeMS Excel Add-in(*.xla)


Gord

On Sat, 23 Jun 2007 19:20:43 +0400, "Vsn" <vsn at hotmail wrote:

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" <gorddibbATshawDOTca wrote in message
.. .
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
ToolsCustomizeCommandsMacros

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

Load the add-in through ToolsAdd-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 + ;<spaceCTRL + SHIFT + ;


Gord Dibben MS Excel MVP

On Fri, 22 Jun 2007 17:38:01 +0400, "Vsn" <vsn at hotmail wrote:

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