Setting Up Workbook Permissions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA and SharePoint permissions 3
Open workbook with password 3
Open Referenced Add In Workbook as Read Only 5
Security 3
Open Add-In (.xla) workbook as Read Only automatically 1
Macro on Password 1
Storing and Accessing Data 1
Linking to Password-required-to-open workbooks 2

Back
Top