ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Disabling "SAVE AS" option under "File" (https://www.excelbanter.com/excel-discussion-misc-queries/78905-disabling-save-option-under-file.html)

Bidyut Bhattacharjee

Disabling "SAVE AS" option under "File"
 
Hi all,
I want to share an excel file on the network. I don't want the users
to Save As ,copy or paste the document beacause the information is sensitive.
Please let me know how can i achive the purpose.

Rebecca

Disabling "SAVE AS" option under "File"
 
Go to Tools/Protection/Protect Sheet

If you uncheck the box, it essentially makes the worksheet a read only file.

"Bidyut Bhattacharjee" wrote:

Hi all,
I want to share an excel file on the network. I don't want the users
to Save As ,copy or paste the document beacause the information is sensitive.
Please let me know how can i achive the purpose.


Dave Peterson

Disabling "SAVE AS" option under "File"
 
You won't be able to stop them.

Heck, they could go into Windows explorer and copy that file and put it anywhere
they want.

Bidyut Bhattacharjee wrote:

Hi all,
I want to share an excel file on the network. I don't want the users
to Save As ,copy or paste the document beacause the information is sensitive.
Please let me know how can i achive the purpose.


--

Dave Peterson

Bidyut Bhattacharjee

Disabling "SAVE AS" option under "File"
 
Hi Rebecca,
The problem is that I have 20 sheets.I have to enter the
password 40 times to make the file read only.Anyways thanks for your response.


Bidyut

"Rebecca" wrote:

Go to Tools/Protection/Protect Sheet

If you uncheck the box, it essentially makes the worksheet a read only file.

"Bidyut Bhattacharjee" wrote:

Hi all,
I want to share an excel file on the network. I don't want the users
to Save As ,copy or paste the document beacause the information is sensitive.
Please let me know how can i achive the purpose.



All times are GMT +1. The time now is 12:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com