View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MarkSussex MarkSussex is offline
external usenet poster
 
Posts: 1
Default Unhide the next worksheet

I have 20 hidden worksheets, their names are P1 to P20 I would like to be
able to unhide the next worksheet by the click of a button. For instance if
say P1, P2 and P3 were already unhiden then clicking the button would find
and unhide the next worksheet P4 in this case and then if clicked again P5
would be unhidden.

Can anyone help?