I would like to write a macro that will select all unlocked cells and clear their contents. all my formulas are in protected cells so only manual input data would be cleared.
is there a code that will select all unlocked cells.
I would like to write a macro that will select all unlocked cells and clear their contents. all my formulas are in protected cells so only manual input data would be cleared.
is there a code that will select all unlocked cells.
Hi there,
Sure - here it is!
Hope this helps,Please Login or Register to view this content.
Greg M
This is awesome. Is there a way to make it clear all of the unprotected cells in the whole workbook, not just one worksheet of the book?
what about merged cells it's not working for them......
Hi, pankajy18,
Welcome to the Forum.
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks