Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Popup Calendar?
Hello. I have six Excel 2003 workbooks that I maintain that are used
throughout the U.S. by our company. Well, we are updating to Excel 2007 so I am making sure that everything is going to work when we switch. I opened all the workbooks in Excel 2007, and then saved them as "Excel Macro-Enabled Workbooks". I noticed that the file sizes on each dropped alot. Since I have a little room now, I want to add more bells and whistles than I had in Excel 2003. So on the sheets where the user enters a date, I selected Calendar Control 12.0 and changed the LinkedCell Property to the cell. But these controls are always visible. On some of the worksheets, there are 4 dates entered, so I need 4 calendar controls (!) Is there a way to keep each of these hidden until I click on the LinkedCell? Thanks for the help! VR/Lost |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Popup Calendar?
See Ron de Bruin's site.
http://www.rondebruin.nl/calendar.htm You don't need four Calendar Controls. One Calendar Control that is triggered by a selection change event within a pre-set range of your choice. Gord Dibben MS Excel MVP On Sun, 25 Oct 2009 19:57:14 -0700 (PDT), Lostguy wrote: Hello. I have six Excel 2003 workbooks that I maintain that are used throughout the U.S. by our company. Well, we are updating to Excel 2007 so I am making sure that everything is going to work when we switch. I opened all the workbooks in Excel 2007, and then saved them as "Excel Macro-Enabled Workbooks". I noticed that the file sizes on each dropped alot. Since I have a little room now, I want to add more bells and whistles than I had in Excel 2003. So on the sheets where the user enters a date, I selected Calendar Control 12.0 and changed the LinkedCell Property to the cell. But these controls are always visible. On some of the worksheets, there are 4 dates entered, so I need 4 calendar controls (!) Is there a way to keep each of these hidden until I click on the LinkedCell? Thanks for the help! VR/Lost |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Popup Calendar?
Hi,
Maybe finished solutions can be more suitable for you like: http://blogs.msdn.com/excel/archive/...e-pickers.aspx http://office.microsoft.com/en-us/ma...CE010584901033 Regards, David "Lostguy" wrote in message ... Hello. I have six Excel 2003 workbooks that I maintain that are used throughout the U.S. by our company. Well, we are updating to Excel 2007 so I am making sure that everything is going to work when we switch. I opened all the workbooks in Excel 2007, and then saved them as "Excel Macro-Enabled Workbooks". I noticed that the file sizes on each dropped alot. Since I have a little room now, I want to add more bells and whistles than I had in Excel 2003. So on the sheets where the user enters a date, I selected Calendar Control 12.0 and changed the LinkedCell Property to the cell. But these controls are always visible. On some of the worksheets, there are 4 dates entered, so I need 4 calendar controls (!) Is there a way to keep each of these hidden until I click on the LinkedCell? Thanks for the help! VR/Lost |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calendar Popup | Excel Programming | |||
calendar popup | Excel Discussion (Misc queries) | |||
Using the popup calendar | Excel Programming | |||
Popup calendar | Excel Programming | |||
Popup calendar | Excel Programming |