I am looking for a macro to attach to a button that will clear cells. the problem i have is i protect the whole sheet and only one a certain cells to unprotect and clear.
I am looking for a macro to attach to a button that will clear cells. the problem i have is i protect the whole sheet and only one a certain cells to unprotect and clear.
Which cells would you like to unprotect and clear?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clicking below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
A5:c31,h5:j31,o5:q31,v5:x31, a38:c64, h38:j64
change password to your actual password. If there isn't a password then delete it.Please Login or Register to view this content.
Hi, superchew,
you could use the volatile setting of protecting the worksheet with the parameter UserInterfaceOnly:=True to allow macros to run without unprotecting the sheet.
Ciao,Please Login or Register to view this content.
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
Test 7.xlsm
This is telling me it can't change part of a merged cell.. I have attached a copy of the form
Hi, superchew,
it would have been an excellent idea to mention MergedCells in the opening post - I never would have answered to this thread then. This doesn´t mean I can´t handle MergedCells in VBA but I´m convinced you would do better when you avoid using them.
Answer to the error message: refer to the complete ranges of the merged cells as well, not only the first cell(s).
Ciao,
Holger
sorry newbie didn't know it mattered.. Thank.
works great thanks.
Hi, superchew,
if your problem has been solved please mark the thread as Solved via Thread Tools above the first post of this thread. Thank you.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks