Hi
try something like

sub all_sheets()
dim wks as worksheet
for each wks in worksheets
wks.column(1).hidden=true
next
end sub


--
Regards
Frank Kabel
Frankfurt, Germany


I have a Sub called ColHidden() which i want to run on every
worksheet
in Workbook "ClearOrClosedSent.xls".
The Worksheets will have different names however.

Can anyone please tell me how to apply the Sub on all worksheets in
the afforementioned workbook?

I am using Excel 2000.

TIA


---
Message posted from http://www.ExcelForum.com/