One option is to rehide the column anytime the selection changes, however this won't prevent user from selecting the entire column and unhiding the row, but as soon as they select a cell, it will be hidden again. There may be some VBA-like solutions that could give you close to what you need, but they won't be perfect and would be very easily defeated by simply disabling macros, rendering your security measures completely ineffective. It would be utilizing the exact same functionality as you are using in the Excel application, so the same limitations that you are finding in using the Sheet protection features will be the same in a VBA solution. In terms of actually preventing users from unhiding columns via the menu options, ultimately the options in VBA are limited as VBA doesn't have any special magic.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |