View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Montana Montana is offline
external usenet poster
 
Posts: 33
Default 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