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
 
S

Simon Lloyd

For question 1, Buy a good book, some thing like Excel Step by Step, bu
a really good start would be to us the macro recorder to record a
everyday task then take a look at the code!, Excel will give you a lo
of code that you don't need but it will give you a good start

As for question 2, look at the macro for the protect/unprotec
portions, directly after .Protect you should see Password:= this will b
the password to unprotect the sheets. If you do not have access to th
code project then i suggest you have a word with the author of thei
workbook

Lois;243703 said:
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 sheet
an
unprotect them, (i just copied the macro from another workbook) howeve
i
keeps saying the password is incorrect & is failing to run. i
addition, i
now wont let me unprotect the spreadsheet manually (tools, protection
unprotect sheet) as it doesnt recognise the password. I have been usin
thi
password in the past to unprotect the workbook! Is there any way i ca
'Hack' into the workbook?
-
Loi

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 

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