Forum Discussion
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 ...
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
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.
could you explain step by step, how to do that and please give me an example file tooPascalKTeam
- 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