Hello Experts
Need Help : Restrict User To Merge / UnMerge Cells In Excel Sheet
i.e.
There are few merge and unmerge cell in my excel sheet, I' don't want user to unmerge the merge cells as well as restrict user to merge the unmerge cells
in short the current cell structure should not destroy
any help will be appreciated.
THANKS
Hi,
Password Protect the worksheet making sure that any cells that ARE permitted to be changed have their cell protection format set to UNLOCKED.
As an aside it's generally acknowledged that it's better to avoid merged cells since they can cause all sorts of problems.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks