Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"assign macro" not an option from short menu | Excel Discussion (Misc queries) | |||
Office2000: Missing Print command in File menu | Excel Discussion (Misc queries) | |||
How do I unlock FILE access? | Excel Discussion (Misc queries) |