Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells?
Marc
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells?
Hi Marc,
if this is multiple choice: Yes If this is an essay: Yes, with macros Your question is much too broad for a newsgroup, though you would find answers in both Google web search and Google Groups search. Concentrate on the searches like hide sheets OR worksheets sub in newsgroups add group:*excel* in web search add excel -forum -hth -julsoft Filter Test, AutoFilter and Hidden Rows/Columns http://www.mvps.org/dmcritchie/excel/filter_tst.htm look for use of word Hide in shortcuts http://www.mvps.org/dmcritchie/excel/shortx2k.htm to unhide hidden rows: select all cells (Ctrl+A except in Excel 2003 use Ctrl+Shift+SpaceBar) or select the rows from before hidden area through after hidden rows then Format, rows, unhide Worksheets in VBA Coding and in Worksheet Formulas http://www.mvps.org/dmcritchie/excel/sheets.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Marc" wrote Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to format only a specific character or number in each cell withina range of cells | Excel Worksheet Functions | |||
Is there away to have specific cells unlock based on the entry of information in another? | New Users to Excel | |||
How can I assign a range starting cell based on a variable locati. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |