Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Authorization for each worksheet
Hi all, I would request your help a problem of mine 1. I have five sheets in a workbook. I have entered codes for the first four sheets and also the formulas. Now, I need only one authorised person to open the first four sheets and anyone to open the fifth sheet. So, the moment anyone opens the workbook, a pop up or a msgbox with push buttons or any select buttons sh:) ould say: i. Authorized ii. Unauthorized. If the person is authorized, it should request a specific password and for the right password, should open all the sheets. If unauthorized, it should open only the fifth sheet. (Note: I have given specific passwords for already created sheets and that should be different from those for the new ones) Your help is requested and appreciated. Thanks, Praveen -- praveen_khm ------------------------------------------------------------------------ praveen_khm's Profile: http://www.excelforum.com/member.php...o&userid=30364 View this thread: http://www.excelforum.com/showthread...hreadid=510274 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Problem reinstallation MS Ofiice on new PC. Authorization Issue | Setting up and Configuration of Excel | |||
VBA Authorization in Win2k | Excel Programming | |||
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming |