how do I select ALL the checkboxes in the Subtotal "Add subtotal to:" dialog box

**iJohn** · 09-14-2012, 03:46 PM

I have a spreadsheet with approximately 50 columns that I want subtotals for. Each time I re-open the spreadsheet and want to use the Subtotal feature, I need to select the check boxes, one by one, of all the columns I want subtotaled. Is there a way I can either:
1. easily check all the check boxes (I tried using the shift and control keys, etc. but this did not work)?; or
2. have the selected check boxes stay checked after closing and re-opening?; or
3. some other solution?

Thank you in advance!!!

**xladept** · 09-14-2012, 08:30 PM

Hi iJohn,

Sub CheckAll(): Dim O As OLEObject, S
For Each O In ActiveSheet.OLEObjects
S = O.Name
If S Like "CheckBox#" Then
ActiveSheet.OLEObjects(S).Object.Value = True
End If: Next: End Sub

**tokiNaples** · 09-27-2024, 05:33 AM

Hello. I have the same question. But I only know the very basics in Excel. Can you describe step by step of how to add this script and begin to use it on Excel please? Thanks a lot!

**zbor** · 09-27-2024, 05:35 AM

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #1 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

how do I select ALL the checkboxes in the Subtotal "Add subtotal to:" dialog box

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

how do I select ALL the checkboxes in the Subtotal "Add subtotal to:" dialog box

Re: how do I select ALL the checkboxes in the Subtotal "Add subtotal to:" dialog box

Re: how do I select ALL the checkboxes in the Subtotal "Add subtotal to:" dialog box

Re: how do I select ALL the checkboxes in the Subtotal "Add subtotal to:" dialog box

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions