| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unhide rows error
I am running the following macro:
Sub open1() ActiveSheet.Unprotect Password:="password" ActiveWindow.DisplayHeadings = True Columns.Hidden = False Rows.Hidden = False ActiveWorkbook.Unprotect Password:="password" Sheets("sheet1").Visible = True Sheets("sheet2").Visible = True Sheets("sheet3").Select Range("P3").Select The problem that I am having is when the macro gets to "Rows.Hidden = False," it corrupts the data in column L in sheet3 & I don't have a clue as to why. Help! Thanks in advance, Montana |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
| unhide row does not unhide the hidden rows | Excel Worksheet Functions | |||
| Hide Rows (Current Date) / Unhide Rows | Excel Programming | |||
| Unhide rows | Excel Discussion (Misc queries) | |||
| Can't Unhide Rows | Excel Programming | |||
Threaded Mode
