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.

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

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

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