Hi

I have the macro as follows:

Sub hide()
'
' hide Macro
' Macro recorded 2004/05/02 by
'
' Keyboard Shortcut: Ctrl+h
'
Columns("M:O").Select
Selection.EntireColumn.Hidden = True
Columns("X:Z").Select
Selection.EntireColumn.Hidden = True
Columns("AI:AK").Select
Selection.EntireColumn.Hidden = True
Columns("AT:AV").Select
Selection.EntireColumn.Hidden = True
Columns("BE:BG").Select
Selection.EntireColumn.Hidden = True
Columns("BP:BR").Select
Selection.EntireColumn.Hidden = True
Columns("CA:CC").Select
Selection.EntireColumn.Hidden = True
Columns("CF:CF").Select
Selection.EntireColumn.Hidden = True
Columns("CM:CM").Select
Selection.EntireColumn.Hidden = True
Columns("CR:CR").Select
Selection.EntireColumn.Hidden = True

End Sub


Everytime I play the macro, it hides everything, need help to sort i
out, as I want it to unhide and hide these columns for view an
printing purposes, well, to fit on page.

I am including a zip file for anyone to see.

my email address is:


Thank

Attachment filename: mastertimesheet6d.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=53153
--
Message posted from http://www.ExcelForum.com