VBA password remover
Remove a supported VBA viewing lock from an authorised .xlsm workbook and save a separate copy. Your file stays in your browser.
Choose your workbook
Already readable, unsigned .xlsm files up to 20 MB.
Use only workbooks you’re authorised to maintain.
Project viewing lock
Saved copy
Choose a workbook
Choose a supported workbook to check its project and create a separate copy.
Identify the lock on the macro project
This VBA password remover removes supported project viewing protection from an already readable .xlsm workbook. It saves a separate copy and keeps your original unchanged.
A Visual Basic for Applications (VBA) project viewing lock controls access to the code in the VBA editor. Microsoft’s project properties guidance describes the Protection tab and its Lock project for viewing setting.
A password requested before Excel opens the workbook protects the whole file. Worksheet protection controls cell editing, and workbook structure protection controls changes to sheets. Those restrictions stay unchanged here.
The tool accepts standard, unsigned .xlsm packages with one embedded VBA project at xl/vbaProject.bin. It supports version 3 compound files and the documented CMG, DPB and GC protection records. Password records must contain a 29-byte hash or the one-byte no-password value.
Legacy .xls files, .xlsb workbooks and other Office containers are outside this tool’s scope. Host-protected projects, signed files and unsupported protection records produce a reason without a download.
Create a separate project-unlocked copy
- Close the original workbook in Excel and keep a backup.
- Choose your authorised .xlsm workbook. The browser reads its package and embedded project without running any macros.
- Wait for Copy ready. The tool checks the saved package against the selected file before enabling the download.
- Download the unlocked copy. Its filename ends in -project-unlocked.xlsm so you can keep it separate from the original.
The transformation changes only the project’s protection state, password record and visibility state in its PROJECT stream. It uses Microsoft’s documented project protection format, clearing the viewing restriction and password, then making the project visible.
The browser compares every other project stream byte for byte, including module and form streams. All workbook package parts outside the embedded project must also match byte for byte. This keeps worksheet data, formulas and drawings in their existing parts.
ZIP compression and compound-file packaging are rebuilt. The tool accepts stored or deflated ZIP entries with conventional ASCII part names. ZIP64, encrypted archives, data descriptors and empty package parts are rejected. Expanded packages must fit within 64 MB.
A project that already has no viewing lock can still produce a separate copy. The result says Already unlocked. Clear file removes the selected file and generated copy from this page.
Verify the project before using the workbook
Open the downloaded copy in desktop Excel with macros disabled. Check that Excel opens it without a repair warning, then open the VBA editor and inspect the project.
Compare the module list and code with your authorised original. Open each form in the designer and check its controls and properties. Confirm that sheet names, formulas and catalogue values still match before replacing a working file.
For a product-price workbook, check a known SKU and its price on the catalogue sheet. Compare its import module and product form with the original project too. Keep both files until those checks pass.
Signed workbooks and recognised VBA signature parts are refused. The tool creates no replacement signature and makes no promise that a signature survives a protection change. Keep a signed original intact and arrange any required signing through its owner.
Removing a viewing lock does not establish that the code is safe to run. Keep your normal macro security settings and review the code before enabling it. Opening-password encryption remains a separate operation.