wilg
04-26-2011, 06:27 PM
Is there anyway to unhide a column without selecting it first? I don't want to move away from the sheet I'm on when it does it..
Sub UnHide_Private_Email()
Call UnProtectAll
Sheets("1 MAINT").Select
Columns("p").Select
Selection.EntireColumn.Hidden = False
Call ProtectAll
End Sub
Thanks again guys.
Mike.
Sub UnHide_Private_Email()
Call UnProtectAll
Sheets("1 MAINT").Select
Columns("p").Select
Selection.EntireColumn.Hidden = False
Call ProtectAll
End Sub
Thanks again guys.
Mike.