If you email me, I'll reply later today with the add-in attached for
you to install.
MedTech wrote:
> well, 3 of us has tried to enter this and none of us can get it to work. Can
> you go thru this step by step to see where we screwed up in the entering..
>
> "MedTech" wrote:
>
> > Thanks, I'll give this a try
> >
> >
> > "JakeyC" wrote:
> >
> > > 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
> > > > >
> > > > >
> > >
> > >
|
Similar Threads
