如何在功能区中禁用或重新导出导出到Excel按钮？ [英] How to Disable or Reroute Export to Excel Button in Ribbon?

问题描述

你好，


我有一个数据库用户点击导出到Excel;功能区中的按钮尝试将报告导出到Excel，当我在报表选择器上有一个按钮，该报表选择器运行我创建的VBA代码以将数据复制到excel模板化报表中。


我的问题是如何将功能区按钮重新路由到我的代码才能正常工作？或者，如果不能这样做，我如何隐藏所有用户的按钮？


提前谢谢！

Hello,

I had a database user click on the "Export to Excel" button in the ribbon to try and export a report to excel when I already have a button on a report selector that runs VBA code I created to copy data into an excel templated report.

My question is how can I reroute the ribbon button to my code that works correctly? Or if that can''t be done, how do I hide the button from all users?

Thanks in advance!

推荐答案

我也将用户需要的所有功能放在表单中。我不确定是否有办法隐藏功能区，以免显示它（我通常将前端分配隐藏，但用户可以轻松再次显示）。


我的工作是，如果你转到左上角的微软按钮，那么访问选项>当前的数据库，你会找到各种锁定某些功能的选项（完整菜单与限制等） - 也许还有一些东西可以隐藏功能区，但我没有广泛关注它。


Pat

I put all the functionality that the users need in the form(s) as well. I''m not sure if there''s a way to keep the ribbon hidden, so as not to display it (I usually distribute front ends with it hidden, but users can easily show it again).

What I do is, if you go to the Microsoft button in the upper left hand corner, then Access Options > Current Database, you''ll find all sorts of options for locking certain functionality out (full menus vs. limited, etc.) - maybe there''s also something in there to keep the ribbon hidden, but I have not looked extensively for it.

Pat

当您取消选中允许完整菜单时和允许默认快捷菜单功能区中的大多数功能都不可用...包括导出/导入操作。

When you uncheck "Allow Full Menus" and "Allow Default Shortcut Menus" most of the functionality in the ribbon is not available...including export/import operations.

不幸的是，取消选中允许完整菜单正在取消从表单视图到数据表视图的切换，这是我们数据库的所有用户经常使用的东西。有不同的解决方案吗？我可以运行的任何VBA代码专门禁用按钮吗？


谢谢。

Unfortunately, unchecking "Allow Full Menus" is taking away the toggle from form view to datasheet view, which is something all users of our database use regularly. Is there a different solution? Any VBA code I could run that specifically disables the button?

Thanks.

这篇关于如何在功能区中禁用或重新导出导出到Excel按钮？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！