Thread
:
How to get a macro to work on another worksheet
View Single Post
#
7
Posted to microsoft.public.excel.programming
Piranha[_22_]
external usenet poster
Posts: 1
How to get a macro to work on another worksheet
RJQMAN,
Put something like this for active sheet at the top of your code:
ActiveSheet.unprotect
Put this at the bottom:
ActiveSheet.protect
If you want a password usesomething like:
ActiveSheet.Unprotect Password:="mypassword"
and:
ActiveSheet.Protect Password:="mypassword"
Something like this will specify certain sheets:
ThisWorkbook.Worksheets("Sheet1).Unprotect("mypass word")
ThisWorkbook.Worksheets("Sheet1).Protect("mypasswo rd")
Dave
Wrote:
Everything you have suggested works! I do not yet understand why mine
did not, but thank you for solving my problem. I am an old dude that
used to program in Fortran - it seemed easy compared to trying to
learn
this. I guess it is partially true - it is hard to teach an old dog
new tricks.
I have another question, which I should probably post as a different
one. Can I have a macro Unprotect a protected sheet and then
re-protect it after the changes have been made? I will repost if I do
not get a response.
Many thanks for your help. I know I will have more questions, and the
help on this newsgroup is extraordinary.
--
Piranha
------------------------------------------------------------------------
Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=20435
View this thread:
http://www.excelforum.com/showthread...hreadid=388589
Reply With Quote
Piranha[_22_]
View Public Profile
Find all posts by Piranha[_22_]