• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Unable to open workbook

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 <<<
Code:
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
 
Last edited by a moderator:

vletm

Excel Ninja
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
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

Excel Ninja
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.
 
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.
 
Top