A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

ho do i insert calendar into xls worksheet



 
 
Thread Tools Display Modes
  #1  
Old November 21st, 2005, 06:19 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default ho do i insert calendar into xls worksheet


  #2  
Old November 21st, 2005, 06:48 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default 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  
Old November 21st, 2005, 06:48 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default 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  
Old November 22nd, 2005, 05:21 AM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default ho do i insert calendar into xls worksheet

Also:

http://www.dotxls.com/free-templates...2006-calendars

  #5  
Old February 13th, 2006, 04:17 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default 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  
Old February 13th, 2006, 04:50 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default 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  
Old February 13th, 2006, 05:16 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default 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  
Old February 13th, 2006, 05:20 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default 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  
Old February 13th, 2006, 05:35 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default 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  
Old February 13th, 2006, 05:47 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 01:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.