LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Protect cells from other users w/out me having to enter pw

I have an excel file on a network drive, other people view it. I changed the
protection so that they can only select and autofilter, but cannot edit
cells. However, I have to unprotect it for myself all the time and then I
save it forgetting to protect it again. There has to be an easier way so
that other people can't edit and I don't have to keep putting in password.
Right?
 
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
protect cells in excel to prevent users from deleting formulae locking cells in excel Excel Discussion (Misc queries) 2 June 14th 06 05:56 PM
Protect Execl data for different users. Saurabh Excel Discussion (Misc queries) 1 May 30th 06 09:28 AM
Protect a worksheet, but allow ONLY specific users to change info tara Excel Worksheet Functions 1 February 18th 06 12:10 AM
How can I protect cells and allow users to insert/delete Jammy Dodger Excel Worksheet Functions 1 January 12th 06 10:20 AM
Protect shouldn't default to "allow users to select locked cells" JudiMicro Setting up and Configuration of Excel 0 November 18th 05 05:00 PM


All times are GMT +1. The time now is 03:38 PM.

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

About Us

"It's about Microsoft Excel"