You could use a worksheet event.

The code unprotects the worksheet, autofits the columns and reprotects the
worksheet.

Rightclick on the worksheet tab that should have this behavior. Select view
code and paste this into the code window:

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Me.Unprotect Password:="password"
Me.Range("d1,F1").EntireColumn.AutoFit
Me.Protect Password:="password"
End Sub

(I used column D and F--you could do more columns (or all of them).)

Change the password to what you need.

Boethius1 wrote:

i have a spreadsheet that i am sharing with someone, i want to leave two
blank columns for them to use, but i want to protect the rest of the
spreadsheet.

I do not know how wide they need the columns to be as this can change,
but if i protect the sheet they cannot widen the columns themselves.

Is there a way to set the columns to autofit?
----------------------------------------------------------:)

--
Boethius1

------------------------------------------------------------------------
Boethius1's Profile: http://www.excelforum.com/member.php...o&userid=30497
View this thread: http://www.excelforum.com/showthread...hreadid=510713

--

Dave Peterson