Hi, I have this worksheet that creates folders automatically through macro. User will select the sub folders that they want created by clicking on "Create" next to the number. I would like to have a "Clear Selection" button that will clear the selection after user executes the command.
I have tried using Range("J3:J32").ClearContents, but I get error message.
Attached is the file
Hello bqheng,
Unprotect the Sheet. Unlock the Cells in Column J, and then when you protect the sheet, allow (or check) the Format cells option.
Regards
Last edited by Winon; 10-30-2013 at 11:22 PM.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi Winon, thanx for the help!!
Hello bqheng,
You are welcome.
Glad I could help.
If you are satisfied with the solution I had given you, then please mark your Thread as Solved.
You may also Click on the Star to the far left, at the bottom of this Post, to Add Reputation.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
bqheng 
Register To Reply
Bookmarks