Saving Macros Files, Trust Center Settings, Locking Projects || Excel VBA Master Class || 1.6
What is the extension for saving a macro file? What are the settings for disabling macros when opening a Excel Macro file? Can we lock the macro code so that no one else can access it? We will answer all these questions in this video.
Topics covered in this lesson are:
Saving:
Using .xlsm and .xlsb file extensions.
Using Personal Macro Workbooks
Brief use case for Add Ins.
Security:
Macro settings for disabling or enabling macros.
Trusted Locations for saving files.
Protection:
Locking VBA projects with a password
#vba #excel
Follow the rest of the series, in the below playlist:
• VBA MasterClass
00:00 Intro
00:36 File Extensions
02:36 Trust Center - Macro Settings
04:36 Trust Center - Trusted Locations
05:52 Personal Macro Workbook
09:00 Locking VBA Project
