| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting Up Workbook Permissions
Thanks, Charles. Gives me something to start with...
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting up a workbook | Setting up and Configuration of Excel | |||
| Shared Workbook & permissions | New Users to Excel | |||
| Setting up Permissions or Security selection spreadsheet | Excel Discussion (Misc queries) | |||
| Setting read only permissions | Excel Discussion (Misc queries) | |||
| Workbook Permissions - How to Control? | Excel Discussion (Misc queries) | |||
![Phil Hageman[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
