LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default allow sort and filter on protected ss

Office 2k(excel)

Our local historical society has created a SS with 5 columns, doc#,
category, date of doc, box#, folder#.
We want people to be able to search the docs, sort and/or filter according
to what they are looking for and print out results of search.
Here's the catch- we don't want them to be able to permanently change any of
the data in the columns AND we want the ss to retain it's original format
when they close out of Excel.
I read that you can disable the save alert using VBA when they close out but
not sure if there is a way for folks to get around this even by mistake.
Also read that the later versions of Office allows more ways to protect the
ss. Would this be the way to go?

Yes, we'll keep a 'clean' backup copy on a different system plus a copy on a
cd/dvd but we'd rather not have to reload it everytime someone uses the
system open to our members.

Thanks for any suggestions.


 
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
Auto filter sort ascending not working while sheet protected TommyB Excel Worksheet Functions 6 March 17th 10 02:51 PM
Using "sort" in auto filter not possible when protected? A. Young Excel Discussion (Misc queries) 0 January 10th 10 02:11 AM
Filter on a protected page WT Excel Discussion (Misc queries) 6 October 17th 08 03:37 PM
filter on a protected sheet peter Setting up and Configuration of Excel 4 July 11th 06 12:04 AM
Filter, sort, filter and then display Andrew[_38_] Excel Programming 2 April 1st 04 12:26 PM


All times are GMT +1. The time now is 01:46 AM.

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"