Nete,
In answer to your comment about posting the code into your version of the workbook and it not working, I would imagine that in your version, the worksheet name still contains the space (I don't have it in front of me, but if the sheet is called "Credit " and the code tries to rererence the checkboxes like this:
Code:
Sheets("Credit").checkboxes("Check Box 32").visible = false
you'll probably get a "Subscript out of range" error message i.e. the code can't find a sheet called "Credit" because in your workbook it's called "Credit " (with a trailing space)
You either need to rename the worksheet to remove the space or alter the code so that the references to the worksheet name INCLUDE the space - i.e. they must match, whichever way you do it.
It can be a problem to rename worksheets in this way, as you don't always know what OTHER code refers to their names!
One way around it is to use TRIM(), which removes trailing and leading spaces (but not those between the words) from a string thus:
Code:
If Trim(UCase(Target.Formula)) = "NEW PROJECT QUOTE" Then
This way, it doesn't matter about the spaces as your check will remove them.
Similarly, the original worksheet range that is referenced by E5 included a cell "Quote " (with a trailing space), so I changed my code to reflect that, as I couldn't unhide the sheet containing the range to make the change there.
Hope this makes sense - please feel free to send me any other problems you encounter - I only have to speak to my wife otherwise!
Pete