Show a calendar in Multiple Worksheets

[Guest]

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

 

[Ron de Bruin]

Hi splodgey

You must insert the control in every worksheet