Worksheet.Protect AllowFormattingCells

[bsquad]

I am running into some issues between Excel 2010 and Excel 2013; if I have on Excel 2013 and open and run it in Excel 2010

worksheet.protect Password:="pw", UserInterfaceOnly:=True

I run into no issues

but if I have

worksheet.protect Password:="pw", UserInterfaceOnly:=True, AllowFormattingColumns:=True, AllowFormattingRows:=True, AllowFormattingCells:=True

I run into crashing and freezing issues on 2010, did 2010 have these parameters or am I missing a Reference library? I know I've had Reference library issues in the past with backwards compatibility, but can't seem to find 2010 parameter list for worksheet.protect

 

[JoeMo]

All the arguments in the latter line of code you posted are valid in XL2010. Are you certain this is the line that causes the problem?

 

[bsquad]

thanks for the response; yes I am certain it is what is causing the issue, it could obviously be in conjunction with parts of other code on it. Although I should note; running the Worksheet.protect doesn't actually cause it to crash; its when I run the other part of the code on it where I basically have a spc copy paste(Formats, ColumnWidths and Values) from another workbook. I unfortunately can't really paste the code because its gigantic - but each time I use only UserInterfaceOnly, it doesn't crash