Forum Discussion

markcooperunilever's avatar
markcooperunilever
Copper Contributor
Nov 01, 2019

How to allow users to merge cells in a protected worksheet?

I have protected a worksheet so users can't change column and row sizes, but I would like allow them to merge cells if/when needed. Is this possible, and if so, how?

excel

1 Reply

  • PReagan's avatar
    PReagan
    Bronze Contributor
    Nov 02, 2019

    Hello markcooperunilever,

     

    This is only possible with the use of VBA. Please refer to the following link:

    https://www.extendoffice.com/documents/excel/4377-excel-protect-sheet-merge-cells.html

Resources