I download excel template from internet. I noticed that excel sheet is password protected and i unable to do any modification. When i try google it, i found one very useful VBA code which will help to cancel or break the lost worksheet protection password.
1. Open your worksheet which has been protected before.
2. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
3. Click Insert > Module
4. Paste the following code in the Module Window.
I have encounter a problem where I have input the figure and using the same formula, but it doesn’t update the correct result even though I have clicked on the ‘Refresh’ button.
Normally, this problem is caused by the Calculation setting for Microsoft Excel.
To update the correct result with formula, please follow the steps as below: Continue reading
Password protecting your Excel Worksheet can prevent others open your works with your permission. To allow only authorized users to view or modify your data, you can help secure your entire workbook file with a password.
To do it, just follow below steps:-
- Open your Excel workbook, on the File menu, click Save As.