Right click sheet menu

**DesM** · 09-14-2007, 12:10 PM

Would anyone have code to allow the sheets in a workbook to be selected from the right click menu?
Des M

**Ron Coderre** · 09-14-2007, 01:30 PM

You can right-click on the |<< >>| buttons to the left of the sheet tabs for a list of sheets you can select. Did you want different functionality?

**DesM** · 09-15-2007, 02:59 AM

Thanks, but I know about the right click on <<>>. It would be better for me to have the selection list on the right click menu when I right click anywhere.
Des M

**royUK** · 09-15-2007, 03:10 AM

There's a free addin to create a toolbar that allows navigation to sheets here

http://www.excel-it.com/vba_examples.htm

**DesM** · 09-15-2007, 11:30 AM

Thanks Roy.
I downloaded the addin and it's good but I would like to be able to select from the right click menu because it is faster than having to pick from a dropdown.
DesM

**Greg M** · 09-15-2007, 01:38 PM

Hi there,

Have I understood correctly - you want to be able to right-click anywhere on a worksheet, display a dropdown list containing the names of all the visible worksheets, and then move automatically to the selected one?

Regards,

Greg M