calendar control - formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
| 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??
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing the month on an inserted calendar in excel 1
External Data Toolbar permanently greyed out. 7
HDMI is a terrible format and I wish it never existed 2
How to Export Gmail Emails to PST Format? 6
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Highlighting duplicates 0
Can't access memory stick 6
new worksheet formatting is DATE 1

Back
Top