personal.xls

[Steve H.]

I wrote a macro (with help from this group) in my personal.xls that displays
a calendar to input dates into the active cell.

I would like to pass this on to my co-workers but can not figure out how to
save personal.xls and if so where to put it on their computers.

Thanks in advance.

Steve

 

[Don Guillett]

They might not like you replacing THEIR personal.xls. Suggest an addin.

 

[Steve H.]

"THEIR" They have no personal.xls and have requested this.

Add-in is good too. Can you point me in the right direction.

 

[Don Guillett]

Just use a new workbook>save as an addin (xlt)> install on their computers
and load the addin.

 

[Steve H.]

Save as calendar.xlt and copied to their computer. Installed the add-in but
nothing changed.

On my machine I have an icon on the toolbar that I can click to get a
calendar to pop up and put the selected date in the active cell.

I am trying to duplicate this for them to get around different variations of
dates being entered.

Any idea why this add-in does not do this?

 

[Bob Phillips]

Steve,

Not .xlt, but .xla. This is the last item in the file types list.

After you have saved it as an add-in, close that file.
Then goto Tools>Add-Ins... and click the browse button.
Go find your new add-in, (.xla remember) and select it. This will add it to
the add-ins list. It will probably be checked already, but make sure it is.
OK Out.

This add-in will automatically load each time Excel starts now.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Don Guillett]

I did say .xlT didn't I?. Sorry, .xlA

 

[Steve H.]

Thanks guys.

Steve

I did say .xlT didn't I?. Sorry, .xlA

--
Don Guillett
SalesAid Software
(e-mail address removed)
variations