{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Home Page","Recording Macros","Writing Macros","Running Macros","Command Button","Locking Macros","Password-Protecting Macros"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home Page","index":0,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Macros in Excel VBA"]
[null,"Let's jump into the fascinating world of Excel macros. Read the provided article covering the essential basics to get started. Also, practice in this section to get in-depth experience with VBA Macros."]
[]
[null,"Prepared By","Yousuf Khan"]
[null,"Reviewed By","Seemanto Saha"]
[null,"Last Update","2023-11-15"]
[null,"Article Link","Learn Excel Macros & VBA Programming"]
[]
[null,"Contents"]
[null,"How to Create Excel VBA Macros"]
[null,"   1. Recording Macros"]
[null,"   2. Writing Macros in Visual Basic Editor"]
[null,"How to Run Macros in Excel VBA"]
[null,"How to Create an Excel Macro using a Command Button"]
[null,"How to Protect Macros in Excel VBA"]
[null,"   1. Lock Macros for Viewing Only"]
[null,"   2. Password-Protecting Macros from Running"]
[]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Recording Macros","index":1,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Macros in Excel VBA",null,null,null,null,null,null,null,null,"Macros in Excel VBA"]
[]
[null,"Recording Macros",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Sub Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Sub Total"]
[null,"5071-1",2,41,{"$f":"C6*D6","v":82},null,null,null,null,null,"5071-1",2,41,{"$f":"L6*M6","v":82}]
[null,"5071-2",5.49,2,{"$f":"C7*D7","v":10.98},null,null,null,null,null,"5071-2",5.49,2,{"$f":"L7*M7","v":10.98}]
[null,null,5,1,5,null,null,null,null,null,null,5,1,5]
[null,null,2.4900000000000002,4,9.9600000000000009,null,null,null,null,null,null,2.4900000000000002,4,9.9600000000000009]
[null,null,4.99,41,204.59,null,null,null,null,null,null,4.99,41,204.59]
[null,null,5.49,26,142.74,null,null,null,null,null,null,5.49,26,142.74]
[null,null,3.99,20,79.800000000000011,null,null,null,null,null,null,3.99,20,79.800000000000011]
[null,null,2.5,39,97.5,null,null,null,null,null,null,2.5,39,97.5]
[null,null,2.99,11,32.89,null,null,null,null,null,null,2.99,11,32.89]
[null,null,5.5,43,236.5,null,null,null,null,null,null,5.5,43,236.5]
[]
[]
[null,"Back to HomePage"]

{"sheet":"Writing Macros","index":2,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Macros in Excel VBA",null,null,null,null,null,null,null,null,"Macros in Excel VBA"]
[]
[null,"Writing Macros in Visual Basic Editor",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Sub Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Sub Total"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},null,null,null,null,null,"5071-1",2.23,41,{"$f":"L6*M6","v":91.429999999999993}]
[null,"5071-2",6.68,2,{"$f":"C7*D7","v":13.36},null,null,null,null,null,"5071-2",6.68,2,{"$f":"L7*M7","v":13.36}]
[null,"5145-1",5.18,1,5.18,null,null,null,null,null,"5145-1",5.18,1,5.18]
[null,"5145-2",5.84,4,23.36,null,null,null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",20.99,41,860.58999999999992,null,null,null,null,null,"5160-1",20.99,41,860.58999999999992]
[null,"5160-2",5.4,26,140.4,null,null,null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",6.47,20,129.4,null,null,null,null,null,"5168-1",6.47,20,129.4]
[null,"5168-2",2.84,39,110.75999999999999,null,null,null,null,null,"5168-2",2.84,39,110.75999999999999]
[null,"5195-1",2.88,11,31.68,null,null,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[null,"Back to HomePage"]

{"sheet":"Running Macros","index":3,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Macros in Excel VBA",null,null,null,null,null,null,null,null,"Macros in Excel VBA"]
[]
[null,"Running Macros",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Sub Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Sub Total"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},null,null,null,null,null,"5071-1",2.23,41,{"$f":"L6*M6","v":91.429999999999993}]
[null,"5071-2",6.68,2,{"$f":"C7*D7","v":13.36},null,null,null,null,null,"5071-2",6.68,2,{"$f":"L7*M7","v":13.36}]
[null,"5145-1",5.18,1,5.18,null,null,null,null,null,"5145-1",5.18,1,5.18]
[null,"5145-2",5.84,4,23.36,null,null,null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",20.99,41,860.58999999999992,null,null,null,null,null,"5160-1",20.99,41,860.58999999999992]
[null,"5160-2",5.4,26,140.4,null,null,null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",6.47,20,129.4,null,null,null,null,null,"5168-1",6.47,20,129.4]
[null,"5168-2",2.84,39,110.75999999999999,null,null,null,null,null,"5168-2",2.84,39,110.75999999999999]
[null,"5195-1",2.88,11,31.68,null,null,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[null,"Back to HomePage"]

{"sheet":"Command Button","index":4,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Macros in Excel VBA",null,null,null,null,null,null,null,null,"Macros in Excel VBA"]
[]
[null,"Creating Macros Using a Command Button",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Sub Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Sub Total"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},null,null,null,null,null,"5071-1",2.23,41,{"$f":"L6*M6","v":91.429999999999993}]
[null,"5071-2",6.68,2,{"$f":"C7*D7","v":13.36},null,null,null,null,null,"5071-2",6.68,2,{"$f":"L7*M7","v":13.36}]
[null,"5145-1",5.18,1,5.18,null,null,null,null,null,"5145-1",5.18,1,5.18]
[null,"5145-2",5.84,4,23.36,null,null,null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",20.99,41,860.58999999999992,null,null,null,null,null,"5160-1",20.99,41,860.58999999999992]
[null,"5160-2",5.4,26,140.4,null,null,null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",6.47,20,129.4,null,null,null,null,null,"5168-1",6.47,20,129.4]
[null,"5168-2",2.84,39,110.75999999999999,null,null,null,null,null,"5168-2",2.84,39,110.75999999999999]
[null,"5195-1",2.88,11,31.68,null,null,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[null,"Back to HomePage"]

{"sheet":"Locking Macros","index":5,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Macros in Excel VBA",null,null,null,null,null,null,null,null,"Macros in Excel VBA"]
[]
[null,"Locking Macros for Viewing Only",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Sub Total",null,null,null,null,null,"Order No","Retail Price","Order Quantity","Sub Total"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},null,null,null,null,null,"5071-1",2.23,41,{"$f":"L6*M6","v":91.429999999999993}]
[null,"5071-2",6.68,2,{"$f":"C7*D7","v":13.36},null,null,null,null,null,"5071-2",6.68,2,{"$f":"L7*M7","v":13.36}]
[null,"5145-1",5.18,1,5.18,null,null,null,null,null,"5145-1",5.18,1,5.18]
[null,"5145-2",5.84,4,23.36,null,null,null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",20.99,41,860.58999999999992,null,null,null,null,null,"5160-1",20.99,41,860.58999999999992]
[null,"5160-2",5.4,26,140.4,null,null,null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",6.47,20,129.4,null,null,null,null,null,"5168-1",6.47,20,129.4]
[null,"5168-2",2.84,39,110.75999999999999,null,null,null,null,null,"5168-2",2.84,39,110.75999999999999]
[null,"5195-1",2.88,11,31.68,null,null,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[null,"Back to HomePage"]

{"sheet":"Password-Protecting Macros","index":6,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Macros in Excel VBA",null,null,null,null,null,null,null,null,"Macros in Excel VBA"]
[]
[null,"Password-Protecting Macros from Running",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Order No","Retail Price","Order Quantity","Sub Total",null,null,"Password: 1234",null,null,"Order No","Retail Price","Order Quantity","Sub Total"]
[null,"5071-1",2.23,41,{"$f":"C6*D6","v":91.429999999999993},null,null,null,null,null,"5071-1",2.23,41,{"$f":"L6*M6","v":91.429999999999993}]
[null,"5071-2",6.68,2,{"$f":"C7*D7","v":13.36},null,null,null,null,null,"5071-2",6.68,2,{"$f":"L7*M7","v":13.36}]
[null,"5145-1",5.18,1,5.18,null,null,null,null,null,"5145-1",5.18,1,5.18]
[null,"5145-2",5.84,4,23.36,null,null,null,null,null,"5145-2",5.84,4,23.36]
[null,"5160-1",20.99,41,860.58999999999992,null,null,null,null,null,"5160-1",20.99,41,860.58999999999992]
[null,"5160-2",5.4,26,140.4,null,null,null,null,null,"5160-2",5.4,26,140.4]
[null,"5168-1",6.47,20,129.4,null,null,null,null,null,"5168-1",6.47,20,129.4]
[null,"5168-2",2.84,39,110.75999999999999,null,null,null,null,null,"5168-2",2.84,39,110.75999999999999]
[null,"5195-1",2.88,11,31.68,null,null,null,null,null,"5195-1",2.88,11,31.68]
[null,"5195-2",19.98,43,859.14,null,null,null,null,null,"5195-2",19.98,43,859.14]
[]
[]
[null,"Back to HomePage"]