Can sheet automation modify locked columns?

Earl Tessmer

Can a move or copy rows automation modify the destination sheet if it has locked columns?

Andrée Starå

Hi @Earl Tessmer

I'm pretty sure that the answer is yes.

Is that what you want, or would you like it not to be able to change at all?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Earl Tessmer

Hello and thanks.

Yes, I need to lock columns so users with edit access cannot alter them. But, I need automation to work.

Andrée Starå

@Earl Tessmer

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!