Copy multiple Data validation to multiple Sheets

[Jp4Real]

Hi, Thanks for reading

I have an existing workbook which spans to 55 Sheets

Now I initially copied 1 sheet and made 52 exact copies (on for each week) and worked my way throught them

Now I need to make a modification to the data Validation of all those sheest at the exact same areas, specifically

I need to data validate C54:C60 and D54:D60 and E54:E60 to another worksheet

Basically I need C54:C60 to =Feuil2!$B$5:$D$5
D54:D60 =Feuil2!$B$6:$D$6
and E54:E60 to =Feuil2!$B$7:$D$7

I know how to do it individually, but I have 52 sheets to go throught, anyway I can do all of them at once, Especially since they all point to the same value just different sheets

thanks !

[harrisonland]

You can edit a number of sheets by holding [CTRL] and clicking the sheets to be changed. Unfortunately, this doesn't work for data validation.

Review and amend the code below, then copy it into a standard module and you'll have a workable start.

Please Login or Register  to view this content.

It's quick and dirty, but it'll save a whole lot of clicking and manual editing if you get it right!

HTH
Tim

[Jp4Real]

Thanks Tim

I however get a Compiler error at

Please Login or Register  to view this content.

I'm not very familliar with VBA anymore, I haven't touched that for... 8 years ha ha

Help would be nice

thanks !

[harrisonland]

It post a copy of your worksheet it'll make it easier to see what's going on.

Tim

[Jp4Real]

Just sent you a PM ! thanks !

[harrisonland]

Hi again. The purpose of having a forum is so that others who may have a similar problem can see the proposed solutions and adapt them to their own problems. It is ordinarily accepted that those with a question do post a (de-sensitised) version of their workbook, so that the specifics of that particular workbook can be taken into account when a solution is proposed. Generally, most helpers do not respond to private messages requesting assistance.

I've attached a workbook that contains the code from post #2; I'm not getting any errors with the code I posted...

If you're still getting an error, please post a copy of your workbook here so we can see where it's going awry.

HTH
Tim

[Jp4Real]

Yo know what, you are absolutely right !

I used your sample and I saw it working well, so I started digging on my workbook (still wasn't working).

Turns out, it was pretty simple, I'd forgotten a sheet that was protected...! lol

Thanks so much that'll save me a lot of clicks !

[harrisonland]

No worries - glad we got there in the end!

Don't forget to mark the thread [SOLVED] if that answers your query...

If you feel it warrants it, you can show some appreciation for those who have helped by clicking the * to leave feedback.

Tim