Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding the popup control calendar after clicking a merged cell??
Hi all,
I'm using ron de bruin's popup calendar code ( http://www.rondebruin.nl/calendar.htm ) in xl2003. It's working great, it dissappears after I click a date and is really a big help. My question is, when somebody accidently clicks on the cell where the calendar is coded to popup (A1:A20), how can they NOT enter a value AND get the calendar to dissappear? I've tried clicking the cells bordering but to no avail (maybe because those cells are merged as b,c,d are one wide cell containing lots of text?) If I click an unmerged cell, then it dissappears, but unmerged cells aren't near the calendar and conveying that message to many users is not easy. So I guess the real question is, how can i get the calendar to dissappear after clicking a non related merged cell? All help is welcome! Thanks! anders -- I''''ve encountered an error and I need to close for the weekend :) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding the popup control calendar after clicking a merged cell??
Hi Anders
Please not use Merged cells (only trouble) Use Center Across Selection instead Select the cells Ctrl 1 Alignment tab in the Horizontal dropdown choose "Center Across Selection " -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Anders" wrote in message ... Hi all, I'm using ron de bruin's popup calendar code ( http://www.rondebruin.nl/calendar.htm ) in xl2003. It's working great, it dissappears after I click a date and is really a big help. My question is, when somebody accidently clicks on the cell where the calendar is coded to popup (A1:A20), how can they NOT enter a value AND get the calendar to dissappear? I've tried clicking the cells bordering but to no avail (maybe because those cells are merged as b,c,d are one wide cell containing lots of text?) If I click an unmerged cell, then it dissappears, but unmerged cells aren't near the calendar and conveying that message to many users is not easy. So I guess the real question is, how can i get the calendar to dissappear after clicking a non related merged cell? All help is welcome! Thanks! anders -- I''''ve encountered an error and I need to close for the weekend :) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding the popup control calendar after clicking a merged cell
Thanks Ron. Works like a charm now. (Just not as pretty :) )
Thanks again. Anders -- I''''ve encountered an error and I need to close for the weekend :) "Ron de Bruin" wrote: Hi Anders Please not use Merged cells (only trouble) Use Center Across Selection instead Select the cells Ctrl 1 Alignment tab in the Horizontal dropdown choose "Center Across Selection " -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Anders" wrote in message ... Hi all, I'm using ron de bruin's popup calendar code ( http://www.rondebruin.nl/calendar.htm ) in xl2003. It's working great, it dissappears after I click a date and is really a big help. My question is, when somebody accidently clicks on the cell where the calendar is coded to popup (A1:A20), how can they NOT enter a value AND get the calendar to dissappear? I've tried clicking the cells bordering but to no avail (maybe because those cells are merged as b,c,d are one wide cell containing lots of text?) If I click an unmerged cell, then it dissappears, but unmerged cells aren't near the calendar and conveying that message to many users is not easy. So I guess the real question is, how can i get the calendar to dissappear after clicking a non related merged cell? All help is welcome! Thanks! anders -- I''''ve encountered an error and I need to close for the weekend :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to control row height and text wrap in non-merged cell ??? | Excel Discussion (Misc queries) | |||
Popup calendar | Excel Discussion (Misc queries) | |||
Calendar control on cell enter? | Excel Worksheet Functions | |||
calendar popup | Excel Discussion (Misc queries) | |||
How to turn off the popup warning when clicking on a hyperlink | Excel Worksheet Functions |