I want to allow users limited ability to format cell fonts, borders and fill.
I execute the following command: Application.CommandBars.ExecuteMso "FormatCellsDialog" from a custom context menu, but the Merge cells option is there.
I don't want to allow users to see or use the Merge cells feature.
The only choices I know of are these:
1. Prevent users from selecting more than 1 cells
2. Unmerge cells if the cells are merged - I can't use this, as merging cells ruins the format and contents of some of the cells in the merged area that can't be fixed.
3. Application.Undo - I can't get this to work. I run the following code:
and it errors out.
So in other words, the only real option I know of, is option 1. Is there a better solution? Ideally I just want a smaller set of format options. Thanks!!
Bookmarks