SOLVED

Selection of Multiple Sheets by one click

Brass Contributor

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

 

 

11 Replies

Hi @Sameer_Kuppanath_Sultan 

 

Please see attached file. Click the image and all sheets are selected. Is that what you need?

Hi 

 

@PascalKTeam 

 

I dont want to use VBA !

 

Also, please note, i need to select 3 sheets out of 4 sheets. 

 

 

 

 

 

 

 

 

 

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. 

Without VBA there is no "1" click solution.

You could select the first sheet, hold down the shift key and then select the last sheet

yes i know that, but i dont want to select all sheets, some selective sheets and they are not in sequence to use shift key. In case of vba, is there any option to save the worksheet as not a macro enabled worksheet. It shall circulate to higher management, and we cant give them hard time to open a macro enabled work book@PascalKTeam 

You could also select the first sheet you want, then the last sheet you want and since you now have too many sheets selected, unselect specific sheets while pressing down the CTRL key.

Does that work for you? If not, VBA is the only option. But the good news are that yes, you could still send the file as xlsx without VBA code

You could also select the first sheet you want, then the last sheet you want and since you now have too many sheets selected, unselect specific sheets while pressing down the CTRL key.- I am trying to reduce this job, since I have 100s of sheets in my work book and sitting each time to do this is impossible. @PascalKTeam 

 

Does that work for you? If not, VBA is the only option. But the good news are that yes, you could still send the file as xlsx without VBA code- How? during closing of work book it ask to change the format to macro enabled workbook. 

You can integrate the VBA code into your personal macro workbook which means that macro is always available when you open excel.
You can then add a button to run the macro to a custom ribbon in your excel menu so it's always there when you need it.
Then you open the file with the 100 sheets, click on the button in the ribbon and voilà, the sheets that you need are selected.

Let me know with which of these steps you need help

could you explain step by step, how to do that and please give me an example file too@PascalKTeam 

best response confirmed by Sameer_Kuppanath_Sultan (Brass Contributor)
Solution

Hi @Sameer_Kuppanath_Sultan 

 

I hope attached video explains how to do it

 

Excellent

 

thanks a lot. it works

@PascalKTeam 

1 best response

Accepted Solutions
best response confirmed by Sameer_Kuppanath_Sultan (Brass Contributor)
Solution

Hi @Sameer_Kuppanath_Sultan 

 

I hope attached video explains how to do it

View solution in original post