Product: How to unlock spreadsheets and macros?
The Home, Tips, Questions and About tabs of our spreadsheets are blocked for the security and privacy of our products and do not alter the functionality of the spreadsheets. Read our privacy policy . When you receive the product by email, double-click on the file and enable the execution of macros (Read this tutorial and watch this video tutorial carefully).
https://www.planilhaideal.com.br/post/como-habilitar-as-macros-de-sua-planilha-ideal
To prevent the user from typing over cells containing formulas, we protect the cells with formulas in subsequent sheets and leave unlocked those cells that can and should be edited. In any case, the cells in supplementary sheets can be unprotected by the user. To do this, go to Review > Unprotect Sheet.
It is very important to extract the zipped file: Right click > Select extractor, such as WinZip (or WinRar) (or 7Zip) > Click Extract here.
Next: Open MS Excel, on Windows, go to File > Options > Trust Center > Trust Center Settings > Macro Settings > Enable Macros and Trust the VBA project template.
Close Excel and reopen it. Then open the extracted spreadsheet in Excel and follow the subsequent steps as per the tutorial and video.