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

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