![free macros for excel free macros for excel](https://www.xlwings.org/assets/images/home/xlwings.png)
VBA code can control or execute the external program, we maybe don’t know if this program is safe or not, it can be as virus to attack our system, so it’s very dangerous for users.įour options of Macro security settings can be choose as below:ġ – Disable all macros without notificationģ – Disable all macros except digitally signed macrosīy default, we choose the second option, when Open a workbook with macros, this setting will prevent macros and pop-up a notification and also give you a choice if enable this macro.ġ# Click on “ Macro Security” in “ Code” group under “ DEVELOPER” Tab.Ģ# click “ Macro Settings”, you will see that four option can be choose.Ĥ# save workbook and choose a macro-enabled file type in the File Type list.ĥ# reopen the above macro-enabled workbook, you will a popup notification.Ħ# click “Enable Content” button to enable Macros or click “close” button to ignore this notification.
#Free macros for excel how to#
The below steps will show you how to run a recorded VBA Macro.Ģ# click “ Macros” button in “ Code” group, then select one Macro that you want to run, click “ Run” button.ģ# you will see that the active cells will be formatted.Ĭustomize the VBA Macro security settings Note: if you select “ This Workbook”, it means that this macro is only available to the current workbook.ģ# now try to perform some actions, such as: formatting the current active cell (set font color to green, set font style to Bold, set fond size to 48).Ĥ# click on “stop Recording” Run a recorded VBA Macro If you don’t know how to write a VBA program in VBA, then Record Macro may be is another good choice to achieve your goal, it will save each of the commands you perform into the Macro so that you can play them again.ġ# Click on “ Record Macro” button in “ Code” groupĢ# enter into a Macro name, such as: “ MyMacro1”, select “ This Workbook” form the drop down list under “ Store macro in:”, then click “ OK”
![free macros for excel free macros for excel](https://powerspreadsheets.com/wp-content/uploads/button-to-enable-macros-in-excel.jpg)
This sub procedure will set the font size to 50 for the current Active Cell.ģ# Click “ Macros” button in Code group, choose “ fontSize” Macro from “ Macro” window, then click “ Run” button.Ĥ# you will see that the font size will set to 50 for the current active cell.