ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   disable built-in menu and short-cut key for cut command (https://www.excelbanter.com/excel-discussion-misc-queries/100590-disable-built-menu-short-cut-key-cut-command.html)

travis

disable built-in menu and short-cut key for cut command
 
I have a spreadsheet setup with cell references to a hidden worksheet that I
use for data entry into our accounting software. I have a macro that takes
the information and converts it into a flat file. Problem is that when
someone else uses the spreadsheet they use the cut/paste rather than
copy/paste to enter redundant information, which blows the references to the
hidden worksheet. This is also true for inserting and deleting rows.

I know how to disable the menu bars, however how do you disable the
short-cut keys and the cut option when using the mouse menus?

Thanks,
Travis

Ron de Bruin

disable built-in menu and short-cut key for cut command
 
See
http://www.rondebruin.nl/menuid.htm

Read the information first

--
Regards Ron de Bruin
http://www.rondebruin.nl



"travis" wrote in message ...
I have a spreadsheet setup with cell references to a hidden worksheet that I
use for data entry into our accounting software. I have a macro that takes
the information and converts it into a flat file. Problem is that when
someone else uses the spreadsheet they use the cut/paste rather than
copy/paste to enter redundant information, which blows the references to the
hidden worksheet. This is also true for inserting and deleting rows.

I know how to disable the menu bars, however how do you disable the
short-cut keys and the cut option when using the mouse menus?

Thanks,
Travis





All times are GMT +1. The time now is 01:56 AM.

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