| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Unhide content .xls 2000
This doesn't sound good!!
If the unhide button is greyed out then it is because the there are no hidden worksheets or the sheet is very hidden using VBA. Paste this module to count your worksheets to establish if it is there or not Sub test() x = Worksheets.Count MsgBox (x) End Sub The essage box will return the number of sheets including any very hidden ones. If it is very hidden then Worksheets("Sheet2").Visible = True Will make it visible again Mike "Tony" wrote: I have created a worksheet in .xls 2000 that appears to have gone into the hide mode? but with one important Malfunction, when I open the file the unhide button on the tool bar is not accessible? Is there anyway around this so as to gain full access to the data therein again? Cheers Tony |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
| how do i unhide a worksheet in excel 2003? unhide tab don't work | Excel Discussion (Misc queries) | |||
| How do I unhide a column when format/column/unhide won't work | Excel Worksheet Functions | |||
| Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
| How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
Threaded Mode
