Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Perhaps try copying this alteration of JE's code:
Public Sub Hide() Range("M:O,X:Z,AI:AK,AT:AV," & _ "BE:BG,BP:BR,CA:CC," & _ "CF:CF,CM:CM,CR:CR") _ .EntireColumn.Hidden = True End Sub Paste that in a general module, not a module associated with the worksheet, then try running it. It worked fine for me. -- Regards, tom Ogilvy "Tom Ogilvy" wrote in message ... It should work in all versions with VBA (xl5 and later). -- Regards, Tom Ogilvy "sonar " wrote in message ... Hi, I am using Excell 2000, would that work on that version? --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel closes down during a macro | Excel Discussion (Misc queries) | |||
Macro Editor closes Excel 2000 ? | Excel Discussion (Misc queries) | |||
macro that closes excel application and open another app | Excel Programming | |||
Macro closes excel and therefore won't run anymore | Excel Programming | |||
Making a macro run when the user closes a workbook | Excel Programming |