PDA

View Full Version : Unhide column without selecting sheet



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.

mbarron
04-26-2011, 07:16 PM
This

Sheets("1 MAINT").Select
Columns("p").Select
Selection.EntireColumn.Hidden = False
can be changed to
Sheets("1 MAINT").Columns("p").EntireColumn.Hidden = False

Aussiebear
04-26-2011, 07:32 PM
Try the following
With Sheets("1 Maint").Columns("P")
.EntireColumn.Hidden = False
rather than using the Select option