Unable to open workbook

[Manish Kumawat]

Dear Excel Ninja

I have a code to execute some tasks but unfortunately i have entered workbook.close property. Now i am unable to open the workbook for editing. Please help me code is pasted below for reference.
There is a private function which calls code "Manish" at the opening

>>> use code - tags <<<

Sub Manish()
Do Until user_input = "Manish" Or user_input = "123"
    user_input = InputBox("Enter the password to use this Calculator", "Password Required")
    Application.Wait (DateAdd("s", 1, Now()))
Workbook.Close Savechanges:=False
Loop

If user_input = "Manish" Or user_input = "123" Then MsgBox "Welcome " & UCase(Application.UserName) & "  You May Proceed!!"
End Sub

 

[vletm]

Manish Kumawat
1) press <SHIFT> -button down ( and keep it pressed )
2) click to open Your Excel-file
3) release Your <SHIFT> -button
4) modify Your code as You want

 

[Manish Kumawat]

Manish Kumawat
1) press <SHIFT> -button down ( and keep it pressed )
2) click to open Your Excel-file
3) release Your <SHIFT> -button
4) modify Your code as You want

Dear Vletm,

Thanks for sharing the method, i tried the same but it is not working. If you have any other method please let me know

Regards,
Manish

 

[vletm]

Manish Kumawat
Upload ... a sample file here.

 

[Manish Kumawat]

Here it is

 

[vletm]

Manish Kumawat
Isn't Your thread ... challenge ... Unable to open workbook ?
It opens as I wrote #3 reply too.

If Your challenge is to modify code,
then You should know its VBAProject Password!
After that, You could modify its code.

 

[Manish Kumawat]

VBA password is 123 but my query is when i open this workbook after enable editing it is asking for the password which is 1234 but when we enter the password the workbook closed by the code.

 

[vletm]

Manish Kumawat
Did You skipped my question?
Isn't Your thread ... challenge ... Unable to open workbook ?
You would get quicker needed help
a) if You would ask - what do You need?
b) if You give valid information.
c) if You would answer to question.

 

[Manish Kumawat]

Thanks