| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prevent user from saving workbook
hi all, Is it possible to prevent a user from saving a workbook, i have a workbook that is for viewing purposes, but would like for it not to be a workbook that can be saved or even prompted to save. If so, how? Any help is very appreciated Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=501522 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Prevent user from saving workbook
The best way is to store it in a network directory where the user has only
view rights and not write rights, tho it would not keep the person from saving it to another location. Other than that, there is no failsafe way. You could use macros, but it's difficult to force people to enable them. If they're not enabled, your security doesn't work. ************ Hope it helps! Anne Troy www.OfficeArticles.com "keithl816" wrote in message ... hi all, Is it possible to prevent a user from saving a workbook, i have a workbook that is for viewing purposes, but would like for it not to be a workbook that can be saved or even prompted to save. If so, how? Any help is very appreciated Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=501522 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Prevent user from saving workbook
Hi Anne, I didn't even think of that, it's on our Z drive, I'll have to change the rights to view only. Thanks, Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=501522 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Prevent user from saving workbook
You're welcome!
************ Hope it helps! Anne Troy www.OfficeArticles.com "keithl816" wrote in message ... Hi Anne, I didn't even think of that, it's on our Z drive, I'll have to change the rights to view only. Thanks, Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=501522 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I prevent someone from deleting a workbook? | Excel Discussion (Misc queries) | |||
| User cannot save excel file in workbook | Excel Worksheet Functions | |||
| prevent a user leaving a blank cell in excel2003 | Excel Discussion (Misc queries) | |||
| problem saving workbook to network location | Excel Discussion (Misc queries) | |||
| Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) | |||
Linear Mode
