how can i lock the width of a column

Topic

New Reply

in excel 2007 how can i lock the width of a column? maually? and using code

many thanks

diana

Reply | Quote

Replies

in excel 2007 how can i lock the width of a column? maually? and using code

many thanks

diana

Protecting the sheet will prevent users from changing the width, but it may be more than you need.

Reply | Quote

You could add workbook macros:

Code:

' examples checking for minimum size for column A


Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Columns("a:A").ColumnWidth < 12 Then Columns("a:A").ColumnWidth = 12 
MsgBox ("before save")
End Sub

Private Sub Workbook_Open()
If Columns("a:A").ColumnWidth < 12 Then Columns("a:A").ColumnWidth = 12 
MsgBox (" On Open ")
End Sub


Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Columns("a:A").ColumnWidth < 12 Then Columns("a:A").ColumnWidth = 12 
End Sub

Reply | Quote

ill test out both your suggestions.

many thanks

diana

Reply | Quote