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