Right-click the Excel file that you cannot open and select Properties. When the Properties dialog shows up, switch to the Security tab. Hit the Edit button to change permissions.

The first thing you should do here is to close all programs that are using the Excel file you are attempting to open. Please ensure the .xls file is not opened in other workbooks, add-ins, or apps.

Now, open the Excel file you want to code sign with your self-signed certificate. (You’ll need to add the Developer tab to your Excel spreadsheet if it’s not already showing.) ...

It is possible to create a macro in an Excel sheet that unlock the sheet which is already protected by a password. Users can easily prepare a document in the sheet and then lock it again with a ...

How to permanently enable a single macro in Excel. If you have an Excel file with a macro, you can easily enable it when you open the spreadsheet. 1. Open the file with the macro in Excel. 2.

Open the CSV file again, select Developer>Macros, select the BranchCSV macro from the list, and click Run. The entire worksheet is organized in one second. Open the CSV file again and run the macro.

After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply ...