Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calender Activex Help
I have drawn a calender on my excel spreadsheet using activeX.
I have a sheet for each month, what I am trying to achive is draw a calender on each of the sheets, lets say it is the January sheet that I am looking at. I only want it to show January on the calender and not be able to change that date so the January sheet would show January and the February sheet would show February. THanks in Advance Joel -- N/A |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calender Activex Help
On Wed, 19 Mar 2008 17:24:09 -0700, Joel
wrote: I only want it to show January on the calender and not be able to change that date so the January sheet would show January and the February sheet would show February. Right click on the calendar and choose Properties. Change ShowDateSelectors to False to get rid of the dropdown boxes. Then right click on the calendar and select View Code. You'll need the following code to prevent the user from clicking on the greyed out numbers and switching months. Private Sub Calendar1_BeforeUpdate(Cancel As Integer) If Sheet1.Calendar1.Month < 1 Then Cancel = True End If End Sub -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pop up calender PT 2 | Excel Discussion (Misc queries) | |||
pop up calender | Excel Discussion (Misc queries) | |||
pop up calender | Excel Discussion (Misc queries) | |||
publish activeX combobox and other activeX control | Excel Programming | |||
CALENDER | Excel Discussion (Misc queries) |