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
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
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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
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
You're welcome!
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
"keithl816" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks