Menu

Macro to ajust columns!

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Don Guillett[_4_] Don Guillett[_4_] is offline

Don Guillett[_4_] is offline

external usenet poster

Posts: 2,337

Default

Macro to ajust columns!

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/

.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to Hide columns	whatzzup	Excel Discussion (Misc queries)	3	October 23rd 09 01:39 PM
going 3 columns over in a macro	ben	New Users to Excel	5	September 15th 08 06:55 PM
Macro lookup columns	Martincito23	Excel Discussion (Misc queries)	2	January 26th 07 05:42 PM
insert columns macro is putting 2 columns instead of 1	AGH	Excel Worksheet Functions	2	February 27th 06 02:36 PM
macro to unmerge columns	HankY	Excel Discussion (Misc queries)	2	December 8th 05 06:04 AM

All times are GMT +1. The time now is 05:33 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement