Work with Excel 2010 VBA

1. Enable VBA Editor if not enabled

Open Excel Options window from File menu and check the Developer

2. Open VBA editor

Click Developer on Excel 2010, the Visual Basic button will appear on the top left. Click on “Visual Basic” to open the VBA editor

3. Lock the VBA code from view for any reasons

Right click the mouse on VBAProject (Book1) and select VBAProject Properties to open the property window.

Select the Protection page, type the password and check  “Lock project for viewing”

4. Write the VBA code, debug and run
5. Add the GUI

   

6.  Save the Excel as the Macros enabled file type (xlsm)