Can I make one or more spreadsheets unopenable?

G

GEM

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?
 
G

Gord Dibben

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

File>Save As>Tools>General Options. Set a password to open at that point.

Save the workbook.


Gord Dibben MS Excel MVP
 
H

Harlan Grove

GEM said:
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?
Click to expand...

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.
 
P

Pete_UK

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
 
H

Harlan Grove

Pete_UK said:
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?
Click to expand...

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.
 
Top