You should be specifying which rows are to be hidden, such as

Rows("3:7").Hidden = False


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Montana" wrote in message
...
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