Thread: Show a calendar in Multiple Worksheets
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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 With QuoteReply With Quote