Sheet Properties

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
F

Frank Kabel

Hi
try the following UDF:
Function get_visible_status(sheetname As String)
get_visible_status = CBool(ActiveWorkbook.Worksheets _
(sheetname).Visible)
End Function
-----Original Message-----
I'm looking for a function or macro that will
Click to expand...
automatically display the visible or hidden properties of
a sheet in a Workbook e.g.
Name Status
Sheet 1000 Visible
Sheet 2000 Hidden
Sheet 3000 Visible

This will allow me to hide sheets, but new users will
Click to expand...
know there are some sheets that are hidden by looking at a
Index of worksheets.
 
Thanks works perfectly!
--
<º}}}><


Frank Kabel said:
Hi
try the following UDF:
Function get_visible_status(sheetname As String)
get_visible_status = CBool(ActiveWorkbook.Worksheets _
(sheetname).Visible)
End Function
-----Original Message-----
I'm looking for a function or macro that will
Click to expand...
automatically display the visible or hidden properties of
a sheet in a Workbook e.g.
Name Status
Sheet 1000 Visible
Sheet 2000 Hidden
Sheet 3000 Visible

This will allow me to hide sheets, but new users will
Click to expand...
know there are some sheets that are hidden by looking at a
Index of worksheets.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hiding an image 2
How do I lookup the sheetname in a workbook 2
This Macro halts any ideas what could be wrong 4
Collapsing all groups 0
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
hide multiple worksheets based on a formula value in one cell 1
Password prompting to unhide worksheet allows temporary visibility 2
Need to have an index sheet but all other sheets should be hidden 1

Back
Top