Security/Protection/Hiding WorkSheets
 

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

Security/Protection/Hiding WorkSheets
 

On Dec 18, 8:42*am, Jeff wrote:
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

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

Security/Protection/Hiding WorkSheets
 

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.




"Jeff" wrote:

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

Security/Protection/Hiding WorkSheets
 

Thanks guys!
--
Jeff


"Michael" wrote:

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.




"Jeff" wrote:

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