I have this very simple macro that clears some cells when i press "clear" button.
Although when i protect the sheet it doesnt work.
Is there a way to avoid this?
Below the code
Thanks![]()
Please Login or Register to view this content.
I have this very simple macro that clears some cells when i press "clear" button.
Although when i protect the sheet it doesnt work.
Is there a way to avoid this?
Below the code
Thanks![]()
Please Login or Register to view this content.
Last edited by tsioumiou; 10-24-2011 at 10:25 AM.
Have the macro unprotect the sheet first and then reprotect at the end:
![]()
Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks