cole7011 said:
include a line for sheet worksheet:
??
"sheet worksheet" ??
The tab is technically called a worksheet. There are at least two ways to reference them, by number, or by the name (the name on the tab). In this case it might be easier to use the worksheet names.
Thus, if your worksheets are named: Source, Work, Copier, House
And you want to hide all but house, then:
Code:
Sheets("Source").Visible = False
Sheets("Work").Visible = False
Sheets("Copier").Visible = False
This will hide the three sheets/worksheets/tabs, and leave House as the only one showing.