| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show a calendar in Multiple Worksheets
Hi I hope someone can help me with this. I've used Ron De Bruin's coding to
show a calendar in Excel and it works really well. My problem occurs when I try to introduce subsequent workbooks. When I put the code in the new spreadsheet get a run time error 424 Object required message. When I go debug it it shows the line Calendar1.Left = Target.Left + Target.Width - Calendar1.Width Any help would appreciated |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show a calendar in Multiple Worksheets
Hi splodgey
You must insert the control in every worksheet -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "splodgey" wrote in message ... Hi I hope someone can help me with this. I've used Ron De Bruin's coding to show a calendar in Excel and it works really well. My problem occurs when I try to introduce subsequent workbooks. When I put the code in the new spreadsheet get a run time error 424 Object required message. When I go debug it it shows the line Calendar1.Left = Target.Left + Target.Width - Calendar1.Width Any help would appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automate calendar dates on worksheets to make a yearly planner | Excel Discussion (Misc queries) | |||
| 2006 calendar on separate worksheets with several cells within a d | Excel Discussion (Misc queries) | |||
| Can I create a dropdown that will show a 2-month calendar? | Excel Worksheet Functions | |||
| How do I show multiple worksheets on multiple screens? | Excel Discussion (Misc queries) | |||
| Pop up calendar won't show in Excel 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
