![]() |
Protecting Excel Options-Tabs
Is there a macro that will place the options menu under password protection
so people cannot acces the tabs? Thank you, Daniel Young |
Protecting Excel Options-Tabs
No. You can disable/hide/delete it. You can replace it with one of your
own design. The user does have the option to reset the menu bar if you don't protect against that. http://support.microsoft.com/default...b;en-us;830502 How to customize menus and menu bars in Excel http://support.microsoft.com/default...b;en-us;166755 File Title: Customizing Menu Bars, Menus, and Menu Items in Microsoft(R) Excel 97 File Name: WE1183.EXE File Size: 58041 bytes File Date: 06/20/97 Keywords: kbfile kbappnote Description: This Application Note can help you learn techniques for writing Visual Basic(R) for Applications code to customize menus in Microsoft Excel 97. This Application Note contains code examples that you can use with the following elements: menu bars, menus, menu items, submenus, and shortcut menus. -- Regards, Tom Ogilvy "Daniel R. Young" wrote in message ... Is there a macro that will place the options menu under password protection so people cannot acces the tabs? Thank you, Daniel Young |
All times are GMT +1. The time now is 08:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com