About Us

L.[_2_]

thanks, will do.

"Dave Peterson" wrote in message
...
I don't know how to implement this.

I'd always send a request to our IT staff (a real department!) when I
needed it.

You may want to ask in a forum dedicated to your network operating system.
Give
as much info as you can when you explain what you need.

"L.S." wrote:

Is this something I can do?
If so, how????

L.

"Dave Peterson" wrote in message
...
Another option that is much, much safer is to get your IT staff
involved.

Tell them you want a common folder that everyone has readonly access --
and only
you (and another trusted coworker (for your vacation/out of office
days)
have
write access).

Then you don't have to worry about the users opening windows explorer
and
deleting the file.

"L." wrote:

Played with your suggested setting and I think that will work fine.
May also use a VBA to disable save and save as function.

Thanks again,

"Dave Peterson" wrote in message
...
Couldn't you just mark the file readonly?

The user will be able to save as a different name, but the original
will
be
safe.

If you want to experiment, you could:
Open windows explorer
traverse to the folder that contains your file
Rightclick on the file and choose properties.
And mark it readonly.

But anyone who knows how to toggle this setting can.

You could also open your workbook
File|SaveAs|tools|general options|and give it a password to modify
(not
open).

When they open the workbook, they'll be prompted for that password
to
modify.
If they know it, they can enter the password and save any changes
they
make.

If they don't know it, then they can still save their workbook using
a
different
name.

======
If you use the windows explorer readonly settings (alone or with the
second
suggestion), excel won't even bother the user with a password
prompt.

Excel knows the file should be opened in readonly mode.

"L.S." wrote:

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.

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Menu

About Us