Advertisements

Excel Password Removal – Excel 2007 / Excel 2010

There are several instances when we would have protected entire Excel Workbooks or specific Worksheets and then totally forgotten about it.  An online search will fetch a thousand options for password removal.

The one on this blog is simple, straight-forward and no software requires to be download. All we need is a simple BASE Script

This has tried and tested on Excel 2007 and 2010 versions

  1. Download the Script file from this link (ScriptFile)
  2. Open the Password Protected Excel File
  3. Press ALT+F11 on your keyboard; the Visual Basic Editor opens
  4. From the File Menu; click Import and select the BASE Script file () that you downloaded earlier
  5. From the File Menu; click Close and Return to Microsoft Excel
  6. From the View Tab in Excel;  Click View Macros (Illustration provided below)
  7. Select Macro1 and Click Run (Illustration provided below)
  8. The password removal utility that opens will guide you through the rest

ViewMacros

ExcelMacro

 

 

Advertisements

About Sunil Padmanabhan

An Indian based out of Dubai who started traveling from 2011 and pretty much caught the travel bug. Every year presents itself as an opportunity to visit and explore a new place.

Posted on May 7, 2014, in Excel, MS Office and tagged , . Bookmark the permalink. 1 Comment.

  1. Open the Password Protected Excel File (Really????? This is the problem!)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: