Hidden Check Box

H

hshayh0rn

I have a spread sheet with some check boxes on it but one of the check boxes
can only be seen when we print the sheet. There is no VB code on the sheet or
the workbook so I'm not sure what could be hiding the box. Any help???????
 
D

Dave Peterson

It sounds more like a display problem.

Sometimes making sure the zoom is 100% will help.

I bet you used the checkboxes from the Control toolbox toolbar. There's a
checkbox on the Forms toolbar that behaves slightly differently when it comes to
formatting and code (but maybe that's not an issue???).

You may want to try those checkboxes (from the Forms Toolbar).
 
H

hshayh0rn

I took a look at what the person who asked me for help did and they are using
checkboxes from the forms toolbar. I checked and the zoom is at 100%. I'm
really stumped!
 
D

Dave Peterson

Any chance that that one hidden one is from the Control toolbox toolbar?

(I don't have any more guesses.)
 
H

hshayh0rn

It MIGHT be but how would I know and if there's no code behind the sheets how
would it be hidden?
 
D

Dave Peterson

Maybe...

Select a single cell
edit|goto|special|objects
Tab between the objects.

Or a small macro...

Option Explicit
Sub testme()
Dim myShape As Shape
For Each myShape In ActiveSheet.Shapes
myShape.Visible = True
Next myShape
End Sub

It MIGHT be but how would I know and if there's no code behind the sheets how
would it be hidden?
Click to expand...
 
Top