column width resize

Hello, I have a worksheet that has several protected cells. Several of the formulas return a long date. I'm running into a problem with making the column width while the sheet is protected. Is there a way to keep the protection and give people the opportunity to modify the column width? I am...

Hi all, need some help as I do not know VBA. I have a form that my company uses to hire new folks. One of the cells is a Organization selection drop-down. Because of what other items are in that column I cannot re-size the whole column but want the drop-down to be wider when it is selected...

Hi, i'm using an event: Target.EntireColumn.AutoFit, but after i've done the work I want a VBA code to find the largest column width and then change the range of columns to that specific width. PlEaSe HeLp

I am using Excel 2007 with real time feeds in 1 of its worksheet. 4 'different' worksheet tab named 'M'; 'M2'; 'M3' & 'M4' are also there but without any macros in it. Due to space constraint in these 4 ws I have been keeping the column widths of the cells as small as required but some extra...

Can anyone help? I found this code on another thread ("Copy to new worksheets") but i need to to retain the column widths when the new tab is created. Any help would be much appreciated. Sub Create_Report() Dim LastRow As Long, LastCol As Integer, i As Long, iStart As Long, iEnd As Long...

Hello! I just have discovered a surefire way to crash my Exel 2007: Trying to change the .ColumnWidth of 3 columns at once, I receive strange behaviour, and a subsequently forever-looping application. In the immediate window I type: Activesheet.Columns("A:C").ColumnWidth=Array(5,15,50) Can...