Vba - insert popup calendar

[hugrl]

HI ALL
trying to insert pop up calendar found this vba works ok in new blank sheet but if I try to enter in to attached sheet come up error
I am trying to get pop up calendar in cells A8 to A150 & G8 to G150 with out success got excel calendar on ok but found vba on here but cant get it to work any help please need to be entered to every month

Please Login or Register  to view this content.

[davesexcel]

You are missing the calendar Control, try this out.
If it works fo r the one sheet you should then be able to get it to work in the WorkBook module

Please Login or Register  to view this content.

When the sheet is activated, a calendar is created and hidden, Move to one sheet then go back to the sheet with the code to create the Calendar

[teylyn]

hugrl, because it's Christmas, I'm not giving you an infraction and I'll change your thread title for you. Normally, you'd have a red card by now!