View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
splodgey splodgey is offline
external usenet poster
 
Posts: 9
Default 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