Macros
 

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

Macros
 

--
__________________________________
HTH

Bob

"Lois" wrote in message
...
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

Macros
 

For question 1, Buy a good book, some thing like Excel Step by Step, but
a really good start would be to us the macro recorder to record an
everyday task then take a look at the code!, Excel will give you a lot
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/unprotect
portions, directly after .Protect you should see Password:= this will be
the password to unprotect the sheets. If you do not have access to the
code project then i suggest you have a word with the author of their
workbook.

Lois;243703 Wrote:
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?!
--
Lois


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=67951