Рет қаралды 25,763
✅ Download the file | www.exceleinfo....
🏆 Subscribe | goo.gl/M5zNA8
In this tutorial I will show you how we can use a macro with VBA code to define if certain users have privileges to modify the structure of an Excel file, especially if they have privileges to modify the reference to the worksheets of an Excel file:
-Insert sheets.
-Eliminate sheets.
-Change name to sheets.
-Move sheets to another file.
-Protect sheet
-Hide and show sheets.
Protect workbook
The option of the page Review - Protect book allows us to protect the structure of an Excel file so as not to modify the sheets that contain an Excel file. Optionally we can assign a password.
User table and User form and password.
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/...
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinf...