Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Helllo.
I have two problems with my check boxes. I have created 3 checkboxes on the same worksheet. when I checkbox1 click I want to delete certain worksheets. When I checkbox2 cliick I want to delete other sheets. I have set up the macro, but when I click the box I get the message "data may exist in the sheets selected for deletion. To permanently delete the data press delete. Is there a way that I do not get the message and it just deletes the sheets? This is a part of my code: Private Sub CheckBox2_Click() Sheets("Education Analysis").Select ActiveWindow.SelectedSheets.Delete Sheets("CostOver ").Select ActiveWindow.SelectedSheets.Delete Sheets("Reclaim").Select ActiveWindow.SelectedSheets.Delete My other problem is that I can check all three checkboxes at the same time. If there any way that I can set it up to only let me check one box and prevent from checking the other boxes. Thanks in advance for any help givien. -- thank you mac |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Question regarding VLookup and if it can check two columns of data | Excel Worksheet Functions | |||
Check box logic question | Excel Worksheet Functions | |||
Question to check the conditions and then print the result. | New Users to Excel | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions |