how to make ####(hash)symbol to disappear and make another sheet works on previous macro?

hi guys,
firstly,i had a problem with ####(hash) symbol.It's keep appearing in sheet "2","3" and so on and i wanna it to be disappeared.secondly,i wanna sheet "2","3",and so on to generate the same task in sheet "1".please help.
ENGBOOKS.xlsm

Select all of the cells containing ####, format cells, number, custom and enter in the TYPE box ;;;
The text will not be seen or printed but still contain the results

Those # symbols means the column is not wide enough to display the value, so if you widen them then you will see TRUE or FALSE as appropriate. If you mean that you do not wish to see the values at all, because of your checkboxes, then you can colour those cells with a white foreground and they will seem to disappear. To do that, select the range C20:S37 then click the Font Colur icon and choose white, then select C20:C37 and return those to black (or automatic) and the same for S20:S37.

Hope this helps.

Pete

Thank you,ncmay and Pete_Uk,but the second task is not been solved.hopefully,i wanna sheet"2","3" and so on would be like sheet"1" which when the SELECT ALL is checked,it will checked all the check boxes and vice-versa.please help.

any help??

hello!,any helps?

fdibbins,thanks for the reminder....