close

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: www.excelforum.com/member.php...oamp;userid=21287
View this thread: www.excelforum.com/showthread...hreadid=501522The 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

quot;keithl816quot; gt; wrote
in message ...
gt;
gt; hi all,
gt;
gt; Is it possible to prevent a user from saving a workbook, i have a
gt; workbook that is for viewing purposes, but would like for it not to be
gt; a workbook that can be saved or even prompted to save. If so, how?
gt;
gt; Any help is very appreciated
gt;
gt; Larry
gt;
gt;
gt; --
gt; keithl816
gt; ------------------------------------------------------------------------
gt; keithl816's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21287
gt; View this thread: www.excelforum.com/showthread...hreadid=501522
gt;

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: www.excelforum.com/member.php...oamp;userid=21287
View this thread: www.excelforum.com/showthread...hreadid=501522You're welcome!
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;keithl816quot; gt; wrote
in message ...
gt;
gt; Hi Anne,
gt;
gt; I didn't even think of that, it's on our Z drive, I'll have to change
gt; the rights to view only.
gt;
gt; Thanks,
gt;
gt; Larry
gt;
gt;
gt; --
gt; keithl816
gt; ------------------------------------------------------------------------
gt; keithl816's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21287
gt; View this thread: www.excelforum.com/showthread...hreadid=501522
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()