An Add-In is simply a standard workbook, but saved as an Add-in (.xla)
instead of the normal .xls so it is 'invisible' when in use. You can
set this option (along with Html, CSV, etc.) during SaveAs.

To install an Add-In, go to Tools - Add-ins and use Browse... to find
the .xla file you saved. Make sure there's a check in the box next to
it in the list of Add-Ins and you're ready to go.

Check Help (F1) for more detailed info.


MedTech wrote:
Now realize that I work with excel and know a little, but doing macros and
visual basic is totally new to me. When you say to have a add in installed...
just how and where do I do this.

"JakeyC" wrote:

One way to do it would be to have an add-in installed with the line:

Application.OnKey "{F8}", "TimeAdder"

in its WorkBook_Open event, and in its Module, the Sub:

Sub TimeAdder()
ActiveCell.Value = Time
End Sub

This would replace the F8 function with this Sub's function.


MedTech wrote:
We use Excel at work and now due to some changes in procedures, we are
required to insert a start and stop time for our testing procedures. While I
know about the control + shift + : to insert time, I was hoping for someway
to change a function key to do this. We have numerous people doing this
testing and it would make life alot easier to just hit one key instead of the
three