The Ultimate Excel Protection Update [Gold & Silver]
Hello Members!
In this week’s Feature, Fix, or Focus, we take last week’s Ultimate Excel Protection training.
Here are the updates I made for this training:
· XML UI Code Added To Workbook requested by Fadhel Hussain
· Sheet Detail Protection added by Randy Austin
Please don’t forget to add your requests for your own Feature, Fix or Focus each week when I post a new video, right here on Patreon. Each week I will either add a new feature, fix a bug or an issue, or create another training with a special focus on any part, all based on your feedback and comments.
Comments (3)
Thanks Randy I appreciate your response
Hello Randy, if a user loads this file to google sheets, they can see every sheet, and all the coding’s even if it’s protected, they cannot se the vba code, put they can see everything else, is there a way to avoid this
Hi and thanks so much. You can avoid this by putting some of the high security items inside vba constants or addins. Addin sheets cannot be viewed inside google sheets. I hope this helps and thanks so much.