Protection / locking

Resolved · Medium Priority · Version 2010

Thu 23 Jun 2016, 16:19 Delegate Michael said...

Michael has attended:
Excel Intermediate course

Protection / locking

If I forget my password how do I unlock my sheets / workbook?

Thu 23 Jun 2016, 19:23 Trainer Jens said...

RE: Protection / locking

Hi Michael,

Thank you for the forum question.

I have done it, but it depend on your knowledge. If you Google Excel Password Remover you can find VBA codes which can do it.

The code need to be executed from the Visual Basic editor in the workbook with the passwords.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 30 Jun 2016: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips