| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calendar drop down ala Ron DeBruin in Excel 2003
I have used Ron DeBruin's method of putting a Calendar date selection control
in my Excel 2003 spreadsheet...it works fine. I then save the file to my flash drive and open it on another computer. It doesn't work. The calendar shows up, won't go away, and the columns that are supposed to be using the drop down control don't have it. I've checked the code and it is OK as far as the columns it defines to have the control. Is there a remedy for this? -- Rich D Armstrong Custom Homes Redmond |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calendar drop down ala Ron DeBruin in Excel 2003
Hi Rich
Is Security set to High on that machine ? ToolsMacroSecurity -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... I have used Ron DeBruin's method of putting a Calendar date selection control in my Excel 2003 spreadsheet...it works fine. I then save the file to my flash drive and open it on another computer. It doesn't work. The calendar shows up, won't go away, and the columns that are supposed to be using the drop down control don't have it. I've checked the code and it is OK as far as the columns it defines to have the control. Is there a remedy for this? -- Rich D Armstrong Custom Homes Redmond |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calendar drop down ala Ron DeBruin in Excel 2003
It's possible, Ron. I'm not htere now to check it. You think that's why?
-- Rich D Armstrong Custom Homes Redmond "Ron de Bruin" wrote: Hi Rich Is Security set to High on that machine ? ToolsMacroSecurity -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... I have used Ron DeBruin's method of putting a Calendar date selection control in my Excel 2003 spreadsheet...it works fine. I then save the file to my flash drive and open it on another computer. It doesn't work. The calendar shows up, won't go away, and the columns that are supposed to be using the drop down control don't have it. I've checked the code and it is OK as far as the columns it defines to have the control. Is there a remedy for this? -- Rich D Armstrong Custom Homes Redmond |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calendar drop down ala Ron DeBruin in Excel 2003
Hi Rich
No code will Run so the events will not hide/show the calendar -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... It's possible, Ron. I'm not htere now to check it. You think that's why? -- Rich D Armstrong Custom Homes Redmond "Ron de Bruin" wrote: Hi Rich Is Security set to High on that machine ? ToolsMacroSecurity -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... I have used Ron DeBruin's method of putting a Calendar date selection control in my Excel 2003 spreadsheet...it works fine. I then save the file to my flash drive and open it on another computer. It doesn't work. The calendar shows up, won't go away, and the columns that are supposed to be using the drop down control don't have it. I've checked the code and it is OK as far as the columns it defines to have the control. Is there a remedy for this? -- Rich D Armstrong Custom Homes Redmond |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calendar drop down ala Ron DeBruin in Excel 2003
"Ron de Bruin" wrote: Hi Rich No code will Run so the events will not hide/show the calendar -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... It's possible, Ron. I'm not htere now to check it. You think that's why? -- Rich D Armstrong Custom Homes Redmond "Ron de Bruin" wrote: Hi Rich Is Security set to High on that machine ? ToolsMacroSecurity -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... I have used Ron DeBruin's method of putting a Calendar date selection control in my Excel 2003 spreadsheet...it works fine. I then save the file to my flash drive and open it on another computer. It doesn't work. The calendar shows up, won't go away, and the columns that are supposed to be using the drop down control don't have it. I've checked the code and it is OK as far as the columns it defines to have the control. Is there a remedy for this? -- Rich D Armstrong Custom Homes Redmond |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calendar drop down ala Ron DeBruin in Excel 2003
I have used your method of putting a Calendar date selection control
in my Excel 2003 spreadsheet. The calendar shows up, won't go away, and the columns that are supposed to be using the drop down control don't have it. I have checked the security - which is set low. Can you suggest a remedy? "Ron de Bruin" wrote: Hi Rich No code will Run so the events will not hide/show the calendar -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... It's possible, Ron. I'm not htere now to check it. You think that's why? -- Rich D Armstrong Custom Homes Redmond "Ron de Bruin" wrote: Hi Rich Is Security set to High on that machine ? ToolsMacroSecurity -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... I have used Ron DeBruin's method of putting a Calendar date selection control in my Excel 2003 spreadsheet...it works fine. I then save the file to my flash drive and open it on another computer. It doesn't work. The calendar shows up, won't go away, and the columns that are supposed to be using the drop down control don't have it. I've checked the code and it is OK as far as the columns it defines to have the control. Is there a remedy for this? -- Rich D Armstrong Custom Homes Redmond |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calendar drop down ala Ron DeBruin in Excel 2003
Hi Claire
Do you copy the code in the correct sheet module -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Claire" wrote in message ... I have used your method of putting a Calendar date selection control in my Excel 2003 spreadsheet. The calendar shows up, won't go away, and the columns that are supposed to be using the drop down control don't have it. I have checked the security - which is set low. Can you suggest a remedy? "Ron de Bruin" wrote: Hi Rich No code will Run so the events will not hide/show the calendar -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... It's possible, Ron. I'm not htere now to check it. You think that's why? -- Rich D Armstrong Custom Homes Redmond "Ron de Bruin" wrote: Hi Rich Is Security set to High on that machine ? ToolsMacroSecurity -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich D" wrote in message ... I have used Ron DeBruin's method of putting a Calendar date selection control in my Excel 2003 spreadsheet...it works fine. I then save the file to my flash drive and open it on another computer. It doesn't work. The calendar shows up, won't go away, and the columns that are supposed to be using the drop down control don't have it. I've checked the code and it is OK as far as the columns it defines to have the control. Is there a remedy for this? -- Rich D Armstrong Custom Homes Redmond |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a drop down/pop-up calendar in excel | Excel Discussion (Misc queries) | |||
| how do I add a drop-down calendar in excel? | Excel Worksheet Functions | |||
| how do I add a calendar function to excel as a drop down? | Excel Worksheet Functions | |||
| How do you create a calendar drop down in excel? | Excel Discussion (Misc queries) | |||
| Outlook 2003 calendar events into Excel 2003? | Excel Discussion (Misc queries) | |||
Linear Mode
