Restricting Access and applying a button

Hi I want myself and a colleague to have an button put on our toolbar (which is only opened and displayed when the workbook is opened or activated. the macro which will be attached to the button will just use a password and lock or unlock all sheets in the activeworkbook. because of this I do not want other users to have this button on their screen. any ideas how to implement this?

Use the workbook_open and the workbook activate and deactivate events to
manage the toolbar. It can check

Environ("Username")

to determine if it is you or your colleage and react appropriately.

As far as a password, you could include prompt in the code for your button
to ask for a password.

Here are some general articles on working with commandbars:

http://support.microsoft.com/?id=159619
XL97: Sample Macros for Customizing Menus and Submenus

http://support.microsoft.com/?id=213550
XL2000: Sample Macros for Customizing Menus and Submenus


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.


http://support.microsoft.com/?id=288771
HOWTO: Create a Transparent Picture For Office CommandBar Buttons


For information on events, see Chip Pearson's page
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy



"funkymonkUK" <funkymonkUK.1srrmk_1122368744.3644@excelforum-nospam.com>
wrote in message
news:funkymonkUK.1srrmk_1122368744.3644@excelforum-nospam.com...
>
> Hi I want myself and a colleague to have an button put on our toolbar
> (which is only opened and displayed when the workbook is opened or
> activated. the macro which will be attached to the button will just use
> a password and lock or unlock all sheets in the activeworkbook. because
> of this I do not want other users to have this button on their screen.
> any ideas how to implement this?
>
>
> --
> funkymonkUK
> ------------------------------------------------------------------------
> funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
> View this thread: http://www.excelforum.com/showthread...hreadid=390116
>

How do I get more Support files which you so kindly provided?

http://support.microsoft.com

should take you to the search screen for the Microsoft Knowledge Base. If
you choose advanced search you can restrict the search to the product you
specify.

--
Regards,
Tom Ogilvy

"funkymonkUK" <funkymonkUK.1ss5j6_1122387050.1924@excelforum-nospam.com>
wrote in message
news:funkymonkUK.1ss5j6_1122387050.1924@excelforum-nospam.com...
>
> How do I get more Support files which you so kindly provided?
>
>
> --
> funkymonkUK
> ------------------------------------------------------------------------
> funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
> View this thread: http://www.excelforum.com/showthread...hreadid=390116
>