date and time control

I have a template sheet with both a LDdate and LDtime drop box on it. I use Code to create a copy of the sheet in a different file...is there a way to make the date and time static once it is selected so when the copied sheet is opened they remane as entered in the template sheet and don't update?

Hi,

With an event macro ...

Please Login or Register  to view this content.

HTH
Carim

Carim,

so where do I put that?? in the event for the LD date and LD time controls?

I can't seem to link the controls to any specific cell...they are just floating there????

maybe I'll make a form to input all that kind of data onto the sheet

An event macro is stored in the worksheet module ...

Go to the worksheet tab
Right click
Select view code
and copy code

HTH
Carim