ExcelBanter - View Single Post

Don Guillett[_4_]

ditto

--
Don Guillett
SalesAid Software

"Tom Ogilvy" wrote in message
...
There was no talk by the original poster of having the action performed on
Entry, or on the fly as you state - thus requiring an event. If that were
the case, the one solution offered, using the worksheet event, would need
to
be entered in 50 sheets and would autofit all 4 columns on each changed of
selection. If on the fly was the requirement, the the workbook level
event
would be appropriate and only one column would possibly be changed based
on
the change events target property. I never suggested that my code should
be
called from an event.

--
Regards,
Tom Ogilvy

wrote in message
...
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/

.