Русские видео

Сейчас в тренде

Иностранные видео


Скачать с ютуб Excel VBA Tips n Tricks #23 Unprotect and Protect, Passwords and Features в хорошем качестве

Excel VBA Tips n Tricks #23 Unprotect and Protect, Passwords and Features 11 лет назад


Если кнопки скачивания не загрузились НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием, пожалуйста напишите в поддержку по адресу внизу страницы.
Спасибо за использование сервиса savevideohd.ru



Excel VBA Tips n Tricks #23 Unprotect and Protect, Passwords and Features

📊 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/

Comments