clear cells macro
To be more specific, I am trying to get a clear button on page one that when
clicked will clear all unprotected cells on pages 2, 3 and 4
"Dorothy" wrote:
I am looking to set up a clear button on sheet 1 that when clicked on will
clear various cells on sheet two.
I have a clear button on sheet 1 that when clicked clears cells on sheet 1
that reads;
Range("A1:A77").ClearContents
but when I try to put that cammand button on page one to clear cells on page
two I can't get the proper script that works.
any help is appreciated.
Dorothy
|