Hi everyone, can anyone help with the following please,

I often hide a lot of sheets before sending them to my boss - he's only
interested in the final report.

Is it possible to insert a button into the sheet that will indicate to
my boss that there are hidden sheets and should he so wish he can click
on it and have a list of the hidden sheets appear. From this he can
select the sheet or sheets he wants to see?

Is this possible?

Also, to speed up my hiding of sheets is it possible to devise a macro
that will list all of the sheets in the book. I will then be able to
select all the sheets i want to hide and have it done on clicking on
'ok'.

Many thanks for your input guys


---
Message posted from http://www.ExcelForum.com/