Forum Discussion

Sameer_Kuppanath_Sultan

Brass Contributor

Jan 15, 2020

Solved

Selection of Multiple Sheets by one click

Hi 🙂

How to select multiple sheets by one click on arranged shape.

Eg

I have following sheets.

Sheet1

Sheet2

Sheet3

Sheet4

I need to seelct Sheet1, Sheet2 and Sheet3 by clicking on a shape/object, is it possible

PascalKTeam
Jan 17, 2020
Hi Sameer_Kuppanath_Sultan

I hope attached video explains how to do it
2020-01-17_10h28_53.mp41.6 MB

11 Replies

PascalKTeam
Iron Contributor
Jan 15, 2020
Hi Sameer_Kuppanath_Sultan

Please see attached file. Click the image and all sheets are selected. Is that what you need?
select all sheets.xlsm33 KB
- Sameer_Kuppanath_Sultan
  Brass Contributor
  Jan 15, 2020
  Hi
  
  PascalKTeam
  
  I dont want to use VBA !
  
  Also, please note, i need to select 3 sheets out of 4 sheets.
  - Sameer_Kuppanath_Sultan
    Brass Contributor
    Jan 15, 2020
    my intention is to report to management with some specified sheets to show, from 100s of sheets in the work book.
    
    I cannot select one by one to hide and unhide.

Resources