use code to allow changing row height and column width in protected worksheet

[niklas]

Hi again,
I have a little macro that allows for some additional flexibility when a worksheet is protected. If I would like the user to be able to change row height and column width I cannot figure out what lines I need to insert. probably something like "enable columnwidth = true" but it does not quite work

Thanks Niklas

Sub auto_open()
     With Worksheets("OtherFcst")
         .protect Password:="sonosfpa", userinterfaceonly:=True
         .EnableOutlining = True
         '.EnableAutoFilter = True
         'If .FilterMode Then
         '   .ShowAllData
         'End If
     End With
End Sub

 

[Hui]

As part of your .Protect line add the following

AllowFormattingColumns:=False, AllowFormattingRows:=False

 

[bobhc]

Good day niklas

You may find this link of help

http://jonhaus.hubpages.com/hub/Setting-Column-Width-and-Using-AutoFit-in-Excel-and-VBA


post moved

 

[niklas]

As part of your .Protect line add the following

AllowFormattingColumns:=False, AllowFormattingRows:=False

Thanks so much - worked beautifully
Niklas