Code to keep open one worksheet or worksheets and close others that are not checked off

**davidingilbert** · 09-14-2022, 07:11 PM

Hello All -

What I need help in is code using an ActiveX check box that will allow me to open either one worksheet or multiple worksheets with the use of checkbox.

If the box is not checked, then those worksheets would become hidden.

I just can't recall how to do it.

Any help is appreciated.

Thank you.
dave

**dangelor** · 09-15-2022, 11:06 AM

Possibly using a toggle...

Please Login or Register  to view this content.

Code to keep open one worksheet or worksheets and close others that are not checked off

LinkBack

Thread Tools

Rate This Thread

Display

Code to keep open one worksheet or worksheets and close others that are not checked off

Re: Code to keep open one worksheet or worksheets and close others that are not checked of

Thread Information

Users Browsing this Thread

Similar Threads

Open and close worksheets from within other worksheets?

[SOLVED] Code to open each WB and run code, by range value then save and close the wb

[SOLVED] Timer , code to check IF worksheet is open else Close it. ??

Application Open/Close Event - Store Open and Close Times?

Code to open a workbook, do what i want, close it, and open the next

worksheet combo box code runs when workbook open and close

Excel should allow all open worksheets to close at once

Bookmarks

Bookmarks

Posting Permissions