Hello,
Is there any VBA code that prevents users from merging cells in a specific range? For instance "Sheet1-10!A21:H60" specifically. I have multiple sheets that require this code but only within this exact cell range. I have searched a bit and found one that affects the whole workbook but there are merged cells outside this range that needs to be merged. Also the users must be able to edit the cells so I can't lock them either. If possible it should be something that detects a merged cell in that range, popsup a warning error and undos, as some users copy and paste into the range.
Also separately, I'd like to ask if its possible to prevent to insert rows or columns within this column A-H and rows 21-60?
Thanks in advance.
Is there any VBA code that prevents users from merging cells in a specific range? For instance "Sheet1-10!A21:H60" specifically. I have multiple sheets that require this code but only within this exact cell range. I have searched a bit and found one that affects the whole workbook but there are merged cells outside this range that needs to be merged. Also the users must be able to edit the cells so I can't lock them either. If possible it should be something that detects a merged cell in that range, popsup a warning error and undos, as some users copy and paste into the range.
Also separately, I'd like to ask if its possible to prevent to insert rows or columns within this column A-H and rows 21-60?
Thanks in advance.
