View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] RJQMAN@AOL.COM is offline
external usenet poster
 
Posts: 9
Default How to get a macro to work on another worksheet

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.