sgmpatnaik
Active Member
Hello Ninja's
Good Morning
I got one problem that is i created one file in 1 year back as Macro Enabled Workbook (.xlsm) and i gave a VB Project password for that file, in that file i used lot of macros and Formulas now i want to view that file but i can't remember the password what i gave.
I tried with Hex Editor but i can't get the DPB name in that file because it is not a .xls and i can't Save As the file because in the workbook module i gave this code
I disable the macro and try to Save As but i can't
so i came here to get some solution from you
Thanks
SP
Good Morning
I got one problem that is i created one file in 1 year back as Macro Enabled Workbook (.xlsm) and i gave a VB Project password for that file, in that file i used lot of macros and Formulas now i want to view that file but i can't remember the password what i gave.
I tried with Hex Editor but i can't get the DPB name in that file because it is not a .xls and i can't Save As the file because in the workbook module i gave this code
Code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI = True Then
MsgBox "Sorry - You may not use the ""Save As ..."" command with this workbook", _
vbExclamation, "Operation not permitted"
Cancel = True
End If
End Sub
I disable the macro and try to Save As but i can't
so i came here to get some solution from you
Thanks
SP
Last edited by a moderator: