LinkBack URL
About LinkBacks
I have several sheets where you fill in the same cells with data which needs to be cleared. Is there a button I can create to clear the data in a select group of cells so I don't have to manually click and delete each input cell? Thanks!
- John
I have several sheets where you fill in the same cells with data which needs to be cleared. Is there a button I can create to clear the data in a select group of cells so I don't have to manually click and delete each input cell? Thanks!
- John
Reopened. headbanger51 has agreed to the rules.
headbanger51,
What are the cells on each sht. Are there any sheets to ignore
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are several sheets and I would want to program the button to clear only the data on that particular sheet. There are a total of four sheets that I would like to have their individual button programmed for. The sheets are also protected so that the only data that can be entered is in the certain select cells...the ones I want the button to "refresh" or clear. I can include one of the sheets if that will help. Thanks!
- John
Last edited by headbanger51; 01-06-2008 at 03:23 PM.
Still need to confirm the range. Is it a block of cells or individual cellsWhat are the cells
VBA Noob
Oh, sorry...they are indivdual cells. I've included one sheet as an example. The cells shaded in light yellow are the input cells that I would like cleared from a button.
- John
Sheets protected
Change Password to your password
Press Alt + F11 > insert module > paste in the below.
See link for how to add buttons
http://www.bettersolutions.com/excel...B926422321.htm
Forms Button
HTH
Please Login or Register to view this content.
VBA Noob
That worked like a champ. Unfortunately, it also opened a can of worms. I have several different sheets in my workbook and some sheets have different cells that need cleared. Other sheets within the workbook I would like to make it impossible to clear cells, as the button I created with this solution would, naturally, clear out the values of the cells on whichever sheet I had up. I'm continuing to research and "plug and chug" but I appreciate the help.
- John
Headbanger, perhaps something like the following might work:
Change your sheet names, ranges and password as needed.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks