Hello,
I'm looking for code (or whatever else) to grey out the user's ability to hide rows and columns for a tab in the worksheet, in Excel 2010.
I've tried numerous codes I found online, but none worked.
I have one that disables the right click on a cell, Sub Disable_Shortcut()CommandBars(21).Enabled = False, but I do not know what the "number" is that corresponds to the other functions I require. And I'm not sure this is the best way to go about this.
Basically, I do not want to user to be able to hide any rows or columns in my spreadsheet.
Any help will be GREATLY appreciated!!
THANK YOU!!!!
Bookmarks