如何禁用namedRange中的单元格移位 [英] How to Disable Shifting Of Cells within namedRange

问题描述

我确实要求停止在指定范围内移动单元格;因为细胞的移位导致我们的应用程序中的数据完整性问题。整个目标是用户应该能够添加整行或删除行，但不能在工作表的特定区域中移动插入
或删除单元格。

I do have requirement of stopping shifting of cells within our named ranges; as shifting of cells leads to data integrity issue in our application. Whole Objective is either user shall be able to add whole row or delete row but shifting of cells from insert or delete shall not be allowed in specific area of worksheet.

我有尝试了替代方法，如隐藏原生插入/删除按钮，并按行和按下我们自己的自定义按钮单元格上下文菜单但我无法禁用CTRL +&快捷键等快捷键。 CTRL - 。

I have tried out alternate approach like Hiding Native Insert/Delete button and pushing our own custom buttons in row & cell context menu. but i am not able to disable shortcut keys like CTRL + & CTRL -.

我们非常感谢您的快速帮助。

Any quick help on this will be highly appreciated.

谢谢，

Bhavik Thakkar

Bhavik Thakkar

推荐答案

嗨Bhavik，

Hi Bhavik,

>>我无法禁用CTRL +&快捷键等快捷键。 CTRL - 。

>> i am not able to disable shortcut keys like CTRL + & CTRL -.

通常，我们可以使用Application.OnKey来禁用特定的密钥或密钥组合。但是通过我的测试，它对CTRL +& CTRL - 。

In general, we could use Application.OnKey to disable a particular key or key combination. But with my test, it would not work for CTRL + & CTRL -.

#Application.OnKey Method（Excel）

https://msdn.microsoft.com/en-us/library/office/ff197461.aspx?f=255&MSPPError = -2147217396

# Application.OnKey Method (Excel)
https://msdn.microsoft.com/en-us/library/office/ff197461.aspx?f=255&MSPPError=-2147217396

对于这个问题，我建议您通过以下链接提交反馈：

< a href ="https://excel.uservoice.com/"> https://excel.uservoice.com/

For this issue, I suggest you submit a feedback in the link below:
https://excel.uservoice.com/

最佳此致，

Best Regards,

Edward

这篇关于如何禁用namedRange中的单元格移位的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！