VBA Macro to run on user selected Workbooks

Hello Members,

I Have A code which is written in Sheet1 Editor..
I.e. On a CommandButton Click it executes..

Now the Code actually unlocks all the Locked cells which are in the workbook

How can we make this code to run on user defined workbooks?

Example - On Command Button click the user will be prompted to select the Excel Workbook
After which this code should get executed on that selected workbook..

Please suggest...

I have Attached the sheet

+Adding - The code actually Bypass the Password on Locked cells & on button click it unlocks the Locked cells on all sheets..

Try the code in the attached file:-

Hi Vikas, I have a File which have locked cell for example..
So its not doing anything... it direct exits from code...

Attaching a sample file on which Column A is locked...

Attaching a sample file on which Column A is locked...

Please ignore duplicate replies.. system issue.. it got stuck

Okay I made a Protected file myself, for testing.
I successfully tested the code after correcting my mistakes.

Check the file in the post #3.

Amazing Vikas !!! Smooth as pie Thanks for sharing