I have a directory with many spreadsheets in it. Other users can view these
spreadsheets. Can I block the access to one or more spreadsheets?

You could move them to a directory only you have access to!

"GEM" wrote:

I have a directory with many spreadsheets in it. Other users can view these
spreadsheets. Can I block the access to one or more spreadsheets?

Place a password to open on those you don't opened and viewed.

FileSave AsToolsGeneral Options. Set a password to open at that point.

Save the workbook.


Gord Dibben MS Excel MVP

On Fri, 20 Jul 2007 10:46:05 -0700, GEM wrote:

I have a directory with many spreadsheets in it. Other users can view these
spreadsheets. Can I block the access to one or more spreadsheets?

"GEM" wrote...
I have a directory with many spreadsheets in it. Other users can view
these spreadsheets. Can I block the access to one or more spreadsheets?

If you have the ability to set permissions in this directory, you could give
yourself (i.e., your own ID) full access to it (or whatever access you
effectively have already), then give the EVERYONE and specific groups
already with specific access permissions only List Folder Contents
permission.

Why don't you rename them with a different extension, eg .xyz instead
of .xls (Excel will warn you about doing this, but just click ok).
Other users won't be able to open them by double-clicking - they will
have to open Excel first and then use File | Open, but if they don't
know that .xyz (or whatever) is an Excel file then why should they try
this?

Hope this helps.

Pete

On Jul 20, 6:46 pm, GEM wrote:
I have a directory with many spreadsheets in it. Other users can view these
spreadsheets. Can I block the access to one or more spreadsheets?

"Pete_UK" wrote...
Why don't you rename them with a different extension, eg .xyz instead
of .xls (Excel will warn you about doing this, but just click ok).
Other users won't be able to open them by double-clicking - they will
have to open Excel first and then use File | Open, but if they don't
know that .xyz (or whatever) is an Excel file then why should they try
this?

Actually, they could open .xyz files by right-clicking on them in Explorer
and using Open with... to choose to open with Excel AND associate the .xyz
file type with Excel.

And if nosy other users have gotten into the habit of nosing through the
OP's directory, I'd bet they can figure all the new .xyz files might just be
the missing .xls files they had come to expect in this directory.