To set security macros and VBA permanently on a laptop or PC, open the Excel Options menu in the top left corner. Select Trust Center and then Trust Center Settings. From there, enable all macros and trust access to the VBA project object model under Macro Settings. This will allow macros and VBA to run without any security warnings each time Excel is opened.
1 of 2
Download to read offline
More Related Content
Baca saya dahulu setting security macro dan vba
1. Setting Security Macro dan VBA
Caranya: (UNTUK SETTING PERMANENT DI LAPTOP/PC)
- Klik Menu Excel Option (Bulatan Sudut Kiri Atas) Ms Excel
- Klik Excel Option
- Klik Trust Center
Klik Menu Excel Option
Klik Excel Option
Klik Trust Centre
2. - Klik Trust Center Settings
- Klik Macro Settings
- Aktifkan (klik/pilih) Enable all macros
- Kemudian Aktifkan (centang) Trust acces to the VBA project object model
(Selesai)
Klik Excel Option
Klik Macro Setting