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 |
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 |
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 |
All times are GMT +1. The time now is 09:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com