How to create a macro button to clear muliple cells on multiple worksheets

Good Evening
I have attached a test workbook excel 2010 (please ignore ref# errors, I've cut the workbook down for uploading purposes)
What I would like to do is have a 'Button' on my 'information Sheet' which when clicked would clear certain cells.
I have searched the forum but can't find a solution, everyone seems to want to delete rows or columns but I just want to clear certain cells.
The workbook will have 11 sheets each named 'caravan 1' through to 'caravan 11'
The uploaded test workbook only only has 3 sheets.

On 'caravan 1' (which is slightly different to the other 10) I want to clear the content of cells

B4 & B5
C4, C22 & C41
D4 & D5
E4,E5, E22,E23,E41 &E 42

On all other 'Caravan sheets' I want to clear the contents of cells

D4 & D5
E4, E5, E22, E23, E41 & E42

It would be icing on the cake if it could give a warning such as " are you sure you want to clear these cells" but that isn't really necessary.
The worksheets will be password protected, but the cells mentioned above will not be.
If it proves too difficult to clear all the cells on all the sheets with one click, then perhaps a simpler solution might be to have a button on each sheet instead

Thanks

You did not specificity where the msg box should appear. It appears on every line before the code clears the cells.

When you mention "C22 & C41" it means cells "C22" and "C41" or from "C22" to "C41"

Do clear contents of specified cells, Just do

Please Login or Register  to view this content.

That's the easiest way on how to do it....Of course there's more optimized methods, but that's it.
If you want a box to confirm...

Please Login or Register  to view this content.

See next code

Please Login or Register  to view this content.