Show a calendar in Multiple Worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top