Sort macro not working on hidden rows?!

Hello Everyone,

I have a macro that I want to run when it is activated but cannot get it to work the way I want it to!
On my sheet different rows between 11 and 35 are hidden. Some of the hidden rows contain data
that I want to reveal when the "PaperWork" Macro is run. The problem is that the macro only sorts
the unhidden cells leaving the hidden cells unsorted! I do not know why but any help is appreciated.
The macro is very basic and below:

Sub PaperWork()
Range("B11:Y35").Select
Selection.Sort Key1:=Range("B11"), Order1:=xlAscending, Header:=xlGuess _
, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub

I have been trying to get this work for about 3 hours now!!!
Thank you very much for any help.

Hello patel45,
I thought about that but the problem is that if i do that there is a different amount of rows being hidden every time! If I unhide / sort / rehide I do not know how many rows to hide as it will be different every time! I cannot take step back twice as the step back will reverse the sort, taking the sheet back to where it was in the first place!
Thank you for your help.