Make a backup copy of a current workbook this is one of the most useful macros which can help you to save a backup copy of current workbook. Some things have not changed like the control tools we offer to help you manage your experience with us. This code will protect all sheets of a Go sub Protectallsheets Dim WS As a Worksheet Dim password As String password Test123 replace Test123 with the password you want for each WS in the worksheet WS. Protect Password: Password next WS End Sub remove protection for all worksheets at once if you have any or all of the worksheets protected you can only apply a slight change of code used to protect the sheet to protect it. Sub Unmergecells selection. Skill End Sub. Open Calculator In the window there is a specific calculator and by using this macro code you can open the calculator directly from Excel use for the calculations. It was a matter of Quora like this: What is a great way to learn and encode VBA I answered the question with my experience and so far 933 people seen the answer and I got 3 votes. Create a Backup of a Current Workbook This is one of the most useful macros which can help you to save a backup file of your current workbook.Some things havent changed like the control tools we provide to help you manage your experience with us.This code will protect all the sheets at one go Sub ProtectAllSheets Dim ws As Worksheet Dim password As String password Test123 replace Test123 with the password you want For Each ws In Worksheets ws.Protect password:password Next ws End Sub Unprotect All Worksheets At One Go If you have some or all of the worksheets protected you can just use a slight modification of the code used to protect sheets to unprotect it.Sub UnmergeCells Selection.UnMerge End Sub. Open Calculator In window there is a specific calculator and by using this macro code you can open that calculator directly from Excel use for your calculations.There was a question on Quora like this one: What is a good way to learn and code VBA I answered the question with my experience and so far 933 people viewed the answer and I got 3 upvotes.