ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   keyboard shortcut to pull up sheet menu(copy,delete,rename,etc)? (https://www.excelbanter.com/excel-discussion-misc-queries/228558-keyboard-shortcut-pull-up-sheet-menu-copy-delete-rename-etc.html)

emd

keyboard shortcut to pull up sheet menu(copy,delete,rename,etc)?
 
Is there a way to pull up the menu to copy,delete,rename,move,etc. a sheet
besides right-clicking on it with a mouse?

Ron de Bruin

keyboard shortcut to pull up sheet menu(copy,delete,rename,etc)?
 
Hi EMD

I think you want to call the Ply menu ?

Try this line in a macro and assign a shortcut to it.
Application.CommandBars("Ply").ShowPopup

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"EMD" wrote in message ...
Is there a way to pull up the menu to copy,delete,rename,move,etc. a sheet
besides right-clicking on it with a mouse?



All times are GMT +1. The time now is 02:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com