Excel 2003 受保护的工作表,不允许 Excel 2000 用户使用自动筛选

发布于 2024-12-07 07:17:37 字数 325 浏览 0 评论 0原文

我已经创建了一个工作电子表格,并试图保护该工作表,以便除了我自己之外没有人可以编辑该文档。我已经对其进行了设置,以便我可以编辑文档的全部内容。在保护设置中,我勾选了任何用户都可以使用自动过滤器的框。

我在应用安全性之前设置了自动过滤器,因此这不是许多论坛建议的问题。然而,我使用的是 Excel 2003,而组织中的大多数人使用的是 Office 2000。我不禁认为这两个系统之间存在一些不兼容性。有人可以建议吗? VBA 宏实际上并不是一个选项,因为组织内的默认设置是只有签名的宏才能运行,但即便如此,它们也必须由最终用户验证(对于 IT 知识较低的用户来说非常烦人)。

有谁知道如何使这项工作有效?

I have created a spreadsheet for work and am trying to protect the sheet so that nobody except myself can edit the document. I have set it up so that I can edit the full range of the document. In the protection setting I have ticked the box that says that any users can use auto-filter.

I have the auto-filter set before applying the security so this is not the issue as many forums would suggest. However I am using Excel 2003 whereas the majority of the organization is using Office 2000. I can't help thinking that there is some incompatibility between the two systems. Can anyone advise? VBA macro's aren't really an option as the default setting within the organization is that only signed macros can run but even then they have to be verified by the end user (very annoying for users with a low IT knowledge).

Does anyone know of a way to make this work?

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(3

一梦等七年七年为一梦 2024-12-14 07:17:38

没有 VBA 这是不可能的。请参阅 http: //office.microsoft.com/en-us/excel-help/enable-autofilter-功能性-for-a-protected-worksheet-HA001098270.aspx

默认情况下,当您保护部分或全部电子表格时,Excel 中的自动筛选功能将变得不可用。如果您使用 Microsoft Office Excel 2003 或 Excel 2002,则可以手动恢复该功能。如果您使用 Excel 2000,则需要使用几行 Microsoft Visual Basic® for Applications (VBA) 代码。

使用 VBA 代码保护工作表并启用自动筛选
Excel 2000 中的功能

此处显示的示例代码保护工作表(不是工作簿)和
为该工作表启用自动筛选功能。代码
仅适用于 Excel 2000。此特定示例会自动运行
当您打开包含受保护工作表的工作簿时。这
代码还包含用于取消工作表保护的密码。

如果尚未启动,请启动 Excel 2000,打开所需的工作簿,然后记下要保护的工作表的名称。
在“工具”菜单上,指向“宏”,然后单击“Visual Basic 编辑器”。

在项目资源管理器中,双击“ThisWorkbook”。

代码窗口中将打开一个新的空白代码模块。

复制以下示例代码并将其粘贴到代码窗口中:

Private Sub Workbook_Open()
     Sheet1.Protect password:="test", DrawingObjects:=True, _
         contents:=True, Scenarios:=True, _
         userinterfaceonly:=True
     Sheet1.EnableAutoFilter = True End Sub

It's not possible without VBA. See http://office.microsoft.com/en-us/excel-help/enable-autofilter-functionality-for-a-protected-worksheet-HA001098270.aspx

By default, the AutoFilter functionality in Excel becomes unavailable when you protect part or all of a spreadsheet. If you use Microsoft Office Excel 2003 or Excel 2002, you can restore that functionality manually. If you use Excel 2000, you need to use a few lines of Microsoft Visual Basic® for Applications (VBA) code.

Use VBA code to protect a worksheet and enable the AutoFilter
functionality in Excel 2000

The sample code shown here protects a worksheet (not a workbook) and
enables the AutoFilter functionality for that worksheet. The code
works only with Excel 2000. This particular sample runs automatically
when you open the workbook that contains the protected worksheet. The
code also contains a password that you use to unprotect the worksheet.

If you haven't already, start Excel 2000, open the desired workbook, and note the name of the worksheet that you want to protect.
On the Tools menu, point to Macro, and then click Visual Basic Editor.

In the Project Explorer, double-click ThisWorkbook.

A new, blank code module opens in the code window.

Copy the following sample code and paste it into the code window:

Private Sub Workbook_Open()
     Sheet1.Protect password:="test", DrawingObjects:=True, _
         contents:=True, Scenarios:=True, _
         userinterfaceonly:=True
     Sheet1.EnableAutoFilter = True End Sub
随梦而飞# 2024-12-14 07:17:37

组织是否允许为您自己和您的用户更改 Excel 中的默认安全设置?

如果没有,您可以轻松创建自己的宏签名。我认为它是 Excel 的一个可选安装组件,允许您根据您的 PC 或用户名创建签名?这不会具有与完整的 Microsoft 验证签名相同的地位,但根据组织的设置,它可能允许您的所有宏被接受。

几年前,这对我在 Excel 2000 上有效,但我仍然必须让每个用户更改其安全设置。我想我还制作了一个宏来自动为每个用户更改安全设置?如果我没记错的话。

Does the organisation allow to change the default security settings within Excel for yourself and your users?

If not you can easily create your own macro signature. I think its an optional install component to Excel that allows you to create the signature based on your PC or username? This will not have the same standing as a full Microsoft verified signature but depending on the organisation's settings it might allow all your macros to be accepted.

This worked for me a few years ago on Excel 2000 but I still had to have each user change their security settings. I think I also made a macro to automate this change in security settings for each user? If I remember correctly.

迷鸟归林 2024-12-14 07:17:37

现在这个问题已经解决了。我们都在使用 Office 2010。

This is solved now. we are all working on Office 2010.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文