I like Bob Phillips' browsesheets macro.

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP

On Thu, 1 Oct 2009 08:40:02 -0700, Al wrote:

I have an excel (2003) document which has quite a number of sheets. I would
like to create a form (msg box) which lists all the sheet names (via a drop
down box) for the user to select which sheet they want to view, then open the
sheet when they click on the sheet name. Help please?