Method Range of object worksheet failed

[Jean Gabriel 10]

I have a multiple sheet Excel sheet and i've included a calendar function to easily change the date of birth using this Explicit option on sheet 6
(Codes on sheet 6)

Please Login or Register  to view this content.

Is there a way to correct this?
Many thanks

[Alf]

Not having seen your workbook I wonder if shg's comment on a solver problem could be why it does not work?

Solver requires all the referenced cells to be on the same sheet. You can put a simple formula in a cell to reference a cell on another sheet.

shg

Alf

[Jean Gabriel 10]

I've solved the problem by disabling the "Worksheet_SelectionChange" event by inserting these codes in the Sub that was calling for the Solver functions

Application.EnableEvents = False
My codes calling the solver
Application.EnableEvents = True

Thanks