Hi
using info I found here in the newsgroup I have inserted the calendar
control so that I can click on a cell and get a drop down.... all works
fine.. I have managed to format the control so it looks as I would
like...however ... when I go to next worksheet and insert the control again
I find that it is default format and I need to go through all the formatting
again... is there a way in which to format the control so that when I insert
it on 10 consecutive worksheets it keeps the same format on all sheets??

Copy and paste the customized control?

--
Jim
"arnoldarmy" wrote in message
...
| Hi
| using info I found here in the newsgroup I have inserted the calendar
| control so that I can click on a cell and get a drop down.... all works
| fine.. I have managed to format the control so it looks as I would
| like...however ... when I go to next worksheet and insert the control
again
| I find that it is default format and I need to go through all the
formatting
| again... is there a way in which to format the control so that when I
insert
| it on 10 consecutive worksheets it keeps the same format on all sheets??