| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Sheets based on checkboxes being unchecked
I have a slight situation that I don't know how to resolve. My IT dept created a userform that prints sheets based on checkboxes that are checked on the userform. The unchecked pages are saved with the checked one's when the file is saved. Is there a way to tell the form to print the checked box (captions) and to delete the unchecked boxs? The checkbox Captions are the names of the actual sheets on the spreadsheet.
For example: If Checkbox "Jeff" is checked, then it would print the sheet "Jeff" but if Checkbox "Mary" is unchecked, then it would delete sheet "Mary" so that it isnt saved. Any way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need code for hiding/unhiding sheets using checkboxes | Excel Worksheet Functions | |||
| Return value(s) based on selected checkboxes | Excel Worksheet Functions | |||
| Return value based on checkboxes selected -- IF() LOOKUP() | Excel Worksheet Functions | |||
| Return value based on checkboxes selected -- IF() LOOKUP() | Excel Worksheet Functions | |||
| Sum Based on Checkboxes | Excel Discussion (Misc queries) | |||
Threaded Mode
