| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password request to run macro
Hi,
I have a workbook with two sheets...one visible to all and one for maintenance. I have written two macros...one to hide the maintenance sheet (amongst other things), the other to unhide them. They are then activated by clicking the relevant buttons that I have created on the face of the visible sheet. What I now need to do is password protect these buttons so that if an unauthorised user clicks on them, XL prompts for a password. Any suggestions? Also, although I am building the workbook in XL XP, the solution needs to also work in '97 and 2000 if possible due to the users requirements. Regards Colin Foster |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Password protection in macro ( Anybody can view my password in VB | Excel Discussion (Misc queries) | |||
| how do I write a request to 'Save As' Macro | Excel Discussion (Misc queries) | |||
| How to see macro code of a password protected macro without a password? | Excel Worksheet Functions | |||
| How Delete Network Password Request-Worksheet in Website | Excel Worksheet Functions | |||
| Request password during Protect macro | Excel Programming | |||
![Colin Foster[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
