У нас вы можете посмотреть бесплатно Excel VBA Tips n Tricks #23 Unprotect and Protect, Passwords and Features или скачать в максимальном доступном качестве, которое было загружено на ютуб. Для скачивания выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса savevideohd.ru
📊 Free Workbooks: https://www.excelvbaisfun.com/links?u... 🥷Join Excel Ninja Pro: https://www.excelvbaisfun.com/ninjapr... Months FREE On Annual Plan Auto Applied) 🥷Excel Ninjas FB Group: https://www.excelvbaisfun.com/xlninjas (Free downloads, Trainings, Live Q&A and more) In this lesson, we discuss some important details with Protecting and UnProtecting a worksheet using VBA Excel. IF you just protect a worksheet in VBA, it WILL NOT INCLUDE YOUR CHECKBOX SELECTIONS, such as allowing users to select or edit cells, delete rows, delete columns, edit objects, format cells, etc. . . We show you how to apply passwords on the unprotect or protect method and how to apply whichever checkboxes you want when protecting. This is useful, for example, when editing something that requires the worksheet to be unprotected. In VBA, you can unprotect the sheet, make your changes in a flash and re-protect it - All at such high speeds, the end user can never detect what happened. Charts are particularly troublesome because some aspects can only be edited when the sheet is unprotected, YES, even when "Edit Objects" is checked when protecting. It's just "one of those things" we have to build workarounds for. The lesson is easy to grasp though, check it out! Fantastic Developer Tools: 🔒 Transform Any Excel File Into A Locked EXE: https://www.excelvbaisfun.com/secure-... (25% off with code ‘25OFF’) 🟡 Create Custom Installers: https://www.excelvbaisfun.com/custom-... 👋 Business Inquiries, Consulting, Comments, etc: https://www.excelvbaisfun.com/contact/