Macros

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?!
 
B

Bob Phillips

--
__________________________________
HTH

Bob

Lois said:
Hi.
I have 2 questions:
1. how does one know the Visual Basic codes to create a macro?


Experience and practice. You can usually use the macro recorder to get you
started.

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?!


See http://www.mcgimpsey.com/excel/removepwords.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top