#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Prevent Saving


Hi there.

I've got a shared sheet that many ppl access daily, but I'm the only
one that should be able to change it (and I do it rarely).

I hate those messages when you open the file asking if you'd like to
input a password to open the file with write access, or to enable a
macro. I'd like to protect the file in a way that it only asks for a
password when I want to overwrite the file.

It's not like I want some great protection, as I know that anyway
someone can simply delete the file and replace it (and I believe anyone
here will do sth like that), I just want to ppl know that they shouldn't
mess with this file, and to know if someone changed it (so I can get my
backup).

Can anyone help me out ?




--
muniz
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I prevent saving an excel file if cells are blank? Leighann Excel Worksheet Functions 1 November 4th 06 07:40 PM
Prevent other from seeing VBA Ed Excel Discussion (Misc queries) 3 October 16th 06 07:27 PM
Prevent The Cruelty [email protected] Excel Worksheet Functions 0 July 24th 06 10:06 AM
Prevent user from saving workbook keithl816 Excel Discussion (Misc queries) 3 January 15th 06 10:24 PM
prevent saving a worksheet looking4help Excel Discussion (Misc queries) 2 March 17th 05 10:14 PM


All times are GMT +1. The time now is 02:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"