How can I toggle sheet tabs on/off using a Check Box?

[VH5150]

I am trying to toggle my sheet tabs on and off using a check box from the forms toolbar. How do I do this?

 

[Mudface]

Try using one from the Control Toolbox, then you can use it's click event as follows-

Private Sub CheckBox1_Click()

ActiveWindow.DisplayWorkbookTabs = CheckBox1

End Sub

Change CheckBox1 to match the name of your checkbox if necessary.

 

[Tom Urtis]

If you are set on the Forms toolbar for your checkbox, then right-click it, left click on Assign Macro, and assign it this one, which goes in a standard module:

Sub Test1()
With ActiveWindow
.DisplayWorkbookTabs = Not .DisplayWorkbookTabs
End With
End Sub

 

[VH5150]

Re: Wow! Works Flawlessly! Thanks

Nice Work.