ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Password option for spreadsheets (https://www.excelbanter.com/excel-programming/359166-password-option-spreadsheets.html)

praveen_khm[_38_]

Password option for spreadsheets
 

Hi all,
I am just wondering if it is possible to insert a module or a code such
that it is user specific.
In detail, there are two types of users: Administrator and User.
If it were administrator, it should ask for a password. If user, it
should give the read-only or a protected form of the spreadsheet. Can
any one help me with this regard?
I just need the workbook to pop-up with a msgbox of administrator/user
with a radio button or a select button. If administrator, it should ask
for a password. Also, disabling the macros should not open the
spreadsheet as making this would lead to nothing. Please help!!!

Thanks,
Pravi


--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile: http://www.excelforum.com/member.php...o&userid=30364
View this thread: http://www.excelforum.com/showthread...hreadid=533854



All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com