Setting Up Workbook Permissions

P

Phil Hageman

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.
 
C

Charles

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
 
C

Charles

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
 
Top