Both Don's and Tom's Marcos are good for a one time
event.
But to Auto Fit columns on the fly, it must be tied to an
event for the worksheet. Using their Macros for a
worksheet event would result in reforming the four columms
on the 50 sheet every time the event occurs.
-----Original Message-----
I have a workbook with @50 tabs. Each tab is setup the
same. I want to
autofit certain columns (F, H, L, M) on all tabs. There
are hidden tabs
(G, I, J, K) that I do not want to autofit.
please help!!!
---
Message posted from http://www.ExcelForum.com/
.