Setting Up Workbook Permissions
 

Is there a way to set up workbook permissions - a user name and password? The result is that anyone could look at the workbook, but only a specified user/password could modify anything.

Setting Up Workbook Permissions
 

Hi,

This is something I use when a user opens a workbook.
The user will have to open as a read only unless they know th
Password. You can modify it.


Workbooks.Open Filename:= _
"G:\USERS\CC\Complaint-KudoFolder\complaintkudofile.xls"
Password:="david"


HTH


Charle

--
Message posted from http://www.ExcelForum.com

Setting Up Workbook Permissions
 

Thanks, Charles. Gives me something to start with...

Setting Up Workbook Permissions
 

HI,

Ok, Just protect the worksheets then, also the workbook. If the use
tries to chang anthing on the worksheet tha is protected they will b
asked for a password.
Click Tools select protection and give it a password.


Charle

--
Message posted from http://www.ExcelForum.com