Protect/lock a few cells but allow column resize

[Tron57]

is it possible to lock a group of cells but still allow column resizing or hide/unhide. The column may or may not be part of the locked cells.

And if it is possible how would I pull this off in VBA. Or even non-VBA for that matter.

thanks

 

[Tron57]

after posting i searched to board to see if this is possbile and i dont even see it asked... kinda bumping this to the top. one of you excel masters must know this.

 

[TheClayTaurus]

in VBA help type "Protect Method"

you can set up a cell to be locked only to prevent it's contents from being changed. this would allow resizing and what not. to do so use this snippet of code:

expression.Protect "Password", DrawingObjects:=False, Contents:=True, Scenarios:=False, UserInterfaceOnly:=False

then you can lock whichever cells you want locked and then the worksheet will protect only their contents.

Let me know if this helps

 

[Tron57]

thanks for the reply...
well that answer is on the right path... i knew how to do that much... but the problem im facing is when i lock the worksheet i am unable to resize columns.
is there a way to protect the contents of a cell but allow column resize?

 

[Excel_Champion]

If using VBA, in order to resize the columns when you have protected the worksheet, you need arguments to the protect code that specifies this as shown below for example:

ActiveSheet.Protect AllowFormattingColumns:=True