Learn to lock and open locked files and sheets. And did you know that you could lock a certain area within a worksheet, while keeping the rest of the sheet locked? This is a handy technique when creating files where you expect the user to fill in some data and send the file back to you.
In this deep-dive video, we will look some tips such as allowing users to filter on the data, while locking the data itself.
Project where this technique is used:
• Excel VBA Automation Project | Send R...
Download Code from my blogsite:
https://skillsandautomation.com/tutor...
Download Macro File from Github:
https://github.com/skillsandautomatio...
Instructions on how to Download the Macro File from Github:
https://skillsandautomation.com/how-t...
00:00 Intro