It is under Developer tab>Insert> Active X Control>Calendar control 12.0
If u dont see Developer tab, then go to excel options>Populer>Developer Tab to activate the same Regards, Prashant On Mon, Aug 17, 2009 at 6:21 PM, big smile <bigsmile...@gmail.com> wrote: > Respected Master of Excel & friends > > I am having Excel 2007 version > > But i can not open the calender in excel sheet - i can not get the tollbar > -- where it is ? > > or please elaborate the system or method to do this good & very inform-able > function of > > calender. > > Is it-- customize quick access tool bar --- > > Please send the soultion. > > Thanks & have a nice day. > > J.shah > > > > > On Fri, Aug 7, 2009 at 8:19 PM, Ayushj <jainayus...@gmail.com> wrote: > >> >> Hi Shafiq, >> >> This is the awesome tip. Appreciate your knowledge. :) >> regards, >> Ayush Jain >> >> On Aug 7, 3:48 pm, shafiq online <shafiq_onl...@hotmail.com> wrote: >> > Dear All, >> > >> > Here is a tip for pop up calendar in Excel. You can display a clander in >> a excel sheet and enter date in a cell by slecting the appropriate date. >> Steps are given below; >> > >> > 1. Open excel work book. >> > >> > 2. go to wiew>Toolbars>Controll Toolbox >> > >> > 3. Now u can see a toolbox window in the sheet. Go to last button (more >> controll) and clink on it. Here u can see a list of controls, click on >> Calendar control 11.0 >> > >> > 4. Adjust the clander in the sheet where you required to be diplayed >> this. >> > >> > 5. Important steps. Double click on calender or right click, then view >> code following code will diplay >> > >> > Private Sub Calendar1_Click() >> > >> > End Sub >> > >> > 6. Enter following lind between 1st and last line >> > >> > ActiveCell.Value = Calendar1.Value >> > >> > 7. Your code will look like this >> > >> > Private Sub Calendar1_Click() >> > ActiveCell.Value = Calendar1.Value >> > End Sub >> > >> > 8. Get out of VBA and go to excel sheet and use the calender. >> > >> > Regards, >> > >> > _________________________________________________________________ >> > Share your memories online with anyone you want. >> http://www.microsoft.com/middleeast/windows/windowslive/products/phot... >> >> > > > > -- Prashant Sent from Masqat, Oman --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
