Uncheck Checkbox on ThisWorkbook > On All Sheets

Hi All!
Having a lil problem on my code. For the current code i used now, it worked only on Sheet1 but not sheet2,3,4.....

Please Login or Register  to view this content.

What should i change in order for excel to uncheck all of the checkbox on every sheets with checkbox in?

BRgds
C.Y.Chua

Try:

Please Login or Register  to view this content.

Hi Mumps1
Thanks for your reply. I had try the code below your show me.
It shown error msg : Next Without For.

It might be other code is wrong or something. Below is my code in 1 module. Sorry to tell you that i am noob for VB.

Please Login or Register  to view this content.

Other than this uncheck thingy. I face another problem, when i copy the command button from Sheet1 to Sheet2, i thought it would work but it dont....

My apologies. I got a couple of lines reversed. Try this:

Please Login or Register  to view this content.

It works brilliantly now.

Sorry to ask for additional stuff, Mumps1.

On Sheet1 my command button work well. When i copy and paste the command button from sheet1 to sheet2. It showed error msg "cannot change part of a merged cell".

As i seen the command button, is based on the sheet2 for the function code of clearing contents. intead of sheet1 which as below,

Please Login or Register  to view this content.

How should i correct this?

It looks like you are trying to clear the contents of cells which are merged. Merged cells most often cause problems in Excel and you should try to avoid them if you can. Try changing the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.