What I would like to see in Excel 2016

[Robert Mika]

Is out for the last few weeks:

https://products.office.com/en-us/office-2016-preview

 

[DocAElstein]

Is out for the last few weeks?

https://products.office.com/en-us/office-2016-preview

Yes, the preview appears to be
Office 2016 public preview now available | Excel Matters

 

[deletedalien]

Here's what I want:

• The ability to multi-select sheets from the Unhide sheets dialog so that I can unhide more than 1 at a time.
• 

Sub UnhideAllSheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
End Sub

Save it to your personal workbook
Then just Customize the ribbon and add it there..

that's what i did....
if i wait for microsoft it could take a while....

 

[MARK858]

@deletedalien, I don't think that was exactly what Jon meant (he is probably aware how to loop through sheets with code ), I think you will find Jon wanted to be able to manually select multiple individual sheets in the unhide sheets dialog... think the equivalent of holding Ctrl and then clicking individual cells in a spreadsheet.

 

[deletedalien]

@deletedalien, I don't think that was exactly what Jon meant (he is probably aware how to loop through sheets with code ), I think you will find Jon wanted to be able to manually select multiple individual sheets in the unhide sheets dialog... think the equivalent of holding Ctrl and then clicking individual cells in a spreadsheet.

ohhh ok ok ok....


Then.... No. hahahaha

 

[RoryA]

(he is probably aware how to loop through sheets with code )

I wouldn't be too sure about that - you'd be amazed at some of the things he doesn't know...

 

[MARK858]

I wouldn't be too sure about that - you'd be amazed at some of the things he doesn't know...

If that is the case I would suggest getting more practice on one of those Excel forums you hear about. Now if I can just remember where I last saw one....

 

[deletedalien]

If that is the case I would suggest getting more practice on one of those Excel forums you hear about. Now if I can just remember where I last saw one....

http://www.excelforum.com/ :D

I'm getting banned huh?.......

 

[MARK858]

Probably not as they tend to not over-react here but maybe not the wisest move to test that.

 

[deletedalien]

Probably not as they tend to not over-react here but maybe not the wisest move to test that.

LOL