If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ho do i insert calendar into xls worksheet
|
#2
|
|||
|
|||
ho do i insert calendar into xls worksheet
halina, here is one way,
http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
#3
|
|||
|
|||
ho do i insert calendar into xls worksheet
Try this site for a download. If you don't like this, then do a search on the web for "Calendars in Excel". http://www.vertex42.com/ExcelTemplat...-template.html -- neopolitan ------------------------------------------------------------------------ neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611 View this thread: http://www.excelforum.com/showthread...hreadid=486902 |
#4
|
|||
|
|||
ho do i insert calendar into xls worksheet
|
#5
|
|||
|
|||
ho do i insert calendar into xls worksheet
Hi Paul,
I need to use in my Excel Form a calender as described. I have done what was recommeded on the webside you are reffering to. While choosing a cell from the range where should be the calendar I receive the Runtime error "424" - object required and the Debug shows this line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width If choosing a cell outside of the range I receive the same runtime error and the Debug shows this line: ElseIf Calendar1.Visible Then Calendar1.Visible = False I use the Excel 2003. Please, can you advice me what the problem is. Thanks a lot. "Paul B" wrote: halina, here is one way, http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
#6
|
|||
|
|||
ho do i insert calendar into xls worksheet
Hi Drahos
Maybe the Calendar you have add to the worksheet is not named Calendar1 Check out the name -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Paul, I need to use in my Excel Form a calender as described. I have done what was recommeded on the webside you are reffering to. While choosing a cell from the range where should be the calendar I receive the Runtime error "424" - object required and the Debug shows this line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width If choosing a cell outside of the range I receive the same runtime error and the Debug shows this line: ElseIf Calendar1.Visible Then Calendar1.Visible = False I use the Excel 2003. Please, can you advice me what the problem is. Thanks a lot. "Paul B" wrote: halina, here is one way, http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
#7
|
|||
|
|||
ho do i insert calendar into xls worksheet
Hi Ron,
you are right. Thanks a lot. Now one more question. I need to have in my form severel cells containing Calendar. The problem is these fields are not in a continuous range but they are on very different places. How can I do this. Now I am not sure but there should be about 8 cells containing calendar. Regards Drahos. "Ron de Bruin" wrote: Hi Drahos Maybe the Calendar you have add to the worksheet is not named Calendar1 Check out the name -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Paul, I need to use in my Excel Form a calender as described. I have done what was recommeded on the webside you are reffering to. While choosing a cell from the range where should be the calendar I receive the Runtime error "424" - object required and the Debug shows this line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width If choosing a cell outside of the range I receive the same runtime error and the Debug shows this line: ElseIf Calendar1.Visible Then Calendar1.Visible = False I use the Excel 2003. Please, can you advice me what the problem is. Thanks a lot. "Paul B" wrote: halina, here is one way, http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
#8
|
|||
|
|||
ho do i insert calendar into xls worksheet
Hi Drahos
Change the Range If Not Application.Intersect(Range("A1:A20,C1,C5,D20"), Target) Is Nothing Then -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Ron, you are right. Thanks a lot. Now one more question. I need to have in my form severel cells containing Calendar. The problem is these fields are not in a continuous range but they are on very different places. How can I do this. Now I am not sure but there should be about 8 cells containing calendar. Regards Drahos. "Ron de Bruin" wrote: Hi Drahos Maybe the Calendar you have add to the worksheet is not named Calendar1 Check out the name -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Paul, I need to use in my Excel Form a calender as described. I have done what was recommeded on the webside you are reffering to. While choosing a cell from the range where should be the calendar I receive the Runtime error "424" - object required and the Debug shows this line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width If choosing a cell outside of the range I receive the same runtime error and the Debug shows this line: ElseIf Calendar1.Visible Then Calendar1.Visible = False I use the Excel 2003. Please, can you advice me what the problem is. Thanks a lot. "Paul B" wrote: halina, here is one way, http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
#9
|
|||
|
|||
ho do i insert calendar into xls worksheet
Wow )
Ron, thank you to much. Drahos. "Ron de Bruin" wrote: Hi Drahos Change the Range If Not Application.Intersect(Range("A1:A20,C1,C5,D20"), Target) Is Nothing Then -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Ron, you are right. Thanks a lot. Now one more question. I need to have in my form severel cells containing Calendar. The problem is these fields are not in a continuous range but they are on very different places. How can I do this. Now I am not sure but there should be about 8 cells containing calendar. Regards Drahos. "Ron de Bruin" wrote: Hi Drahos Maybe the Calendar you have add to the worksheet is not named Calendar1 Check out the name -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Paul, I need to use in my Excel Form a calender as described. I have done what was recommeded on the webside you are reffering to. While choosing a cell from the range where should be the calendar I receive the Runtime error "424" - object required and the Debug shows this line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width If choosing a cell outside of the range I receive the same runtime error and the Debug shows this line: ElseIf Calendar1.Visible Then Calendar1.Visible = False I use the Excel 2003. Please, can you advice me what the problem is. Thanks a lot. "Paul B" wrote: halina, here is one way, http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
#10
|
|||
|
|||
ho do i insert calendar into xls worksheet
You are welcome
-- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Wow ) Ron, thank you to much. Drahos. "Ron de Bruin" wrote: Hi Drahos Change the Range If Not Application.Intersect(Range("A1:A20,C1,C5,D20"), Target) Is Nothing Then -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Ron, you are right. Thanks a lot. Now one more question. I need to have in my form severel cells containing Calendar. The problem is these fields are not in a continuous range but they are on very different places. How can I do this. Now I am not sure but there should be about 8 cells containing calendar. Regards Drahos. "Ron de Bruin" wrote: Hi Drahos Maybe the Calendar you have add to the worksheet is not named Calendar1 Check out the name -- Regards Ron de Bruin http://www.rondebruin.nl "Drahos" wrote in message ... Hi Paul, I need to use in my Excel Form a calender as described. I have done what was recommeded on the webside you are reffering to. While choosing a cell from the range where should be the calendar I receive the Runtime error "424" - object required and the Debug shows this line: Calendar1.Left = Target.Left + Target.Width - Calendar1.Width If choosing a cell outside of the range I receive the same runtime error and the Debug shows this line: ElseIf Calendar1.Visible Then Calendar1.Visible = False I use the Excel 2003. Please, can you advice me what the problem is. Thanks a lot. "Paul B" wrote: halina, here is one way, http://www.rondebruin.nl/calendar.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "halina" wrote in message ... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Insert Picture Error | Lynda | Powerpoint | 19 | November 22nd, 2005 10:00 PM |
can you insert a comment into a protected worksheet? | TKGerdie | Worksheet Functions | 3 | October 18th, 2005 04:32 PM |
can I insert a calendar page into a Publisher brochure template? | Cheska99 | Publisher | 3 | September 22nd, 2005 09:26 PM |
Insert worksheet | Krish | General Discussion | 2 | July 12th, 2004 01:22 AM |
auto insert copy of worksheet | Bernie Deitrick | Worksheet Functions | 0 | March 4th, 2004 03:18 PM |