Security/Protection/Hiding WorkSheets

[Jeff]

My workbook contains 7 sheets.

I would like only one sheet to be visible to users, which they will use to
enter info (one cell from data validation list) which will then display
results.

Suggestions Please?

thanks!

 

[mick22306]

My workbook contains 7 sheets.

I would like only one sheet to be visible to users, which they will use to
enter info (one cell from data validation list) which will then display
results.

Suggestions Please?

thanks!

Jeff,
One possible solution: right click on any tab and pick "view code";
that will open Microsoft Visual Basic window. on the upper left side
you'll see your sheets listed under "VBAProject\Microsoft Excel
Objects". Left click on any of the those listed sheets; on the lower
left part of the window, (Properties Sheet) on the bottom line you'll
see "Visible". Pull down the menu next to "visible" and select "0" or
"2" for "hidden" or "veryhidden" respectively. repeat that for all
the sheets you want to hide. Then close out visual basic and your
sheets should be hidden.
Hope that works as you need
-JoelS

 

[Michael]

Modify this to suit your needs; this will hide all sheets except Sheet1:

Sub hideme()

Dim wk As Worksheet
For Each wk In Worksheets
If wk.Name <> "Sheet1" Then
wk.Visible = False
End If
Next wk

End Sub

 

[Jeff]

Thanks guys!
--
Jeff

Modify this to suit your needs; this will hide all sheets except Sheet1:

Sub hideme()

Dim wk As Worksheet
For Each wk In Worksheets
If wk.Name <> "Sheet1" Then
wk.Visible = False
End If
Next wk

End Sub

--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.