L
Lois
Hi.
I have 2 questions:
1. how does one know the Visual Basic codes to create a macro?
2. I have a workbook with a macro that is set to protect all the sheets and
unprotect them, (i just copied the macro from another workbook) however it
keeps saying the password is incorrect & is failing to run. in addition, it
now wont let me unprotect the spreadsheet manually (tools, protection,
unprotect sheet) as it doesnt recognise the password. I have been using this
password in the past to unprotect the workbook! Is there any way i can
'Hack' into the workbook?!
I have 2 questions:
1. how does one know the Visual Basic codes to create a macro?
2. I have a workbook with a macro that is set to protect all the sheets and
unprotect them, (i just copied the macro from another workbook) however it
keeps saying the password is incorrect & is failing to run. in addition, it
now wont let me unprotect the spreadsheet manually (tools, protection,
unprotect sheet) as it doesnt recognise the password. I have been using this
password in the past to unprotect the workbook! Is there any way i can
'Hack' into the workbook?!