pop up date picker wont work when sheet is protected

Hello Everyone,

I am hoping someone will be able to show me the error of my ways please.
I have copied a calender and modified the code to add dates in the boxes I needed, but when I protect my sheet the code doesnt work can anyone help me out please?

Many thanks

Jamie.c

jamie.c , your password is secret and not Secret

Please Login or Register  to view this content.

Thank you so much, silly mistake!

Now that it works I want to apply it to numerous workbooks, but I cannot seem to copy the calender over as I did from the original, how can I do this? I cannot seem to find the original thread that I copied it from

Can anyone help please?

Many thanks

Jamie.c

----any help or advice would be much appreciated---------

Many thanks

Jamie.c

Originally Posted by jamie.c

----any help or advice would be much appreciated---------

Many thanks

Jamie.c

something as annex ? New sheet with ............

Morning trucker10,

Sorry I probably didnt explain what I meant that well. When I first added that calender to the workbook I copied & pasted it from one I found on this site, then copied and pasted the code, and altered it to suit my project, now its in the book I cant seem to repeat that process to add it to a seperate workbook.

Any help or advice would be much appreciated,

Thanks for your reply

Jamie.c

good afternoon Jamie C take a look at this site

Hello trucker10,

Thanks very much for your help, Il have a play with it.

Kind regards

Jamie.c