ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Check boxes (https://www.excelbanter.com/excel-discussion-misc-queries/105108-check-boxes.html)

MACAVITY500

Check boxes
 
I have added check boxes to my spreadsheets and I would like to be able to
tick or clear them all in one go. Is this possible rather than ticking them
individually one by one?

Dave F

Check boxes
 
Try this:

Edit--GoTo--Special--Objects and see if you can check or uncheck them all
at once.

"MACAVITY500" wrote:

I have added check boxes to my spreadsheets and I would like to be able to
tick or clear them all in one go. Is this possible rather than ticking them
individually one by one?


MACAVITY500

Check boxes
 
My edit menu has "object" greyed out so this option seems unavailable. Any
other ideas?

"Dave F" wrote:

Try this:

Edit--GoTo--Special--Objects and see if you can check or uncheck them all
at once.

"MACAVITY500" wrote:

I have added check boxes to my spreadsheets and I would like to be able to
tick or clear them all in one go. Is this possible rather than ticking them
individually one by one?


Dave F

Check boxes
 
Go back to the edit menu and follow this menu path:

Edit--Go To--Special--Objects

Ignore the 'objects' you see when you first open the Edit menu. That's not
what I'm talking about.

"MACAVITY500" wrote:

My edit menu has "object" greyed out so this option seems unavailable. Any
other ideas?

"Dave F" wrote:

Try this:

Edit--GoTo--Special--Objects and see if you can check or uncheck them all
at once.

"MACAVITY500" wrote:

I have added check boxes to my spreadsheets and I would like to be able to
tick or clear them all in one go. Is this possible rather than ticking them
individually one by one?


MACAVITY500

Check boxes
 
It's saying "No objects found"

"Dave F" wrote:

Go back to the edit menu and follow this menu path:

Edit--Go To--Special--Objects

Ignore the 'objects' you see when you first open the Edit menu. That's not
what I'm talking about.

"MACAVITY500" wrote:

My edit menu has "object" greyed out so this option seems unavailable. Any
other ideas?

"Dave F" wrote:

Try this:

Edit--GoTo--Special--Objects and see if you can check or uncheck them all
at once.

"MACAVITY500" wrote:

I have added check boxes to my spreadsheets and I would like to be able to
tick or clear them all in one go. Is this possible rather than ticking them
individually one by one?


MACAVITY500

Check boxes
 
It's saying "No Objects Found" any more advice?

"Dave F" wrote:

Go back to the edit menu and follow this menu path:

Edit--Go To--Special--Objects

Ignore the 'objects' you see when you first open the Edit menu. That's not
what I'm talking about.

"MACAVITY500" wrote:

My edit menu has "object" greyed out so this option seems unavailable. Any
other ideas?

"Dave F" wrote:

Try this:

Edit--GoTo--Special--Objects and see if you can check or uncheck them all
at once.

"MACAVITY500" wrote:

I have added check boxes to my spreadsheets and I would like to be able to
tick or clear them all in one go. Is this possible rather than ticking them
individually one by one?



All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com