Link to home
Start Free TrialLog in
Avatar of pauls681
pauls681

asked on

Restrict printing and copying in Excel

Is there any way to restrict printing and copying a spraedsheet to another location in excel?  
We have a mix of office 2000 and 2003.
This person is useing 2000 but could be upgraded is need be.

We are running 2000/XP for WS and Novell 6.5 for server.
Any suggestions?
Avatar of [ fanpages ]
[ fanpages ]

Convert the ".xls" workbook file to an Adobe Acrobat Portable Document Format ".pdf" file & apply restrictions to the usage of the file of the type you mentioned.
Avatar of pauls681

ASKER

I did think of that but I wanted to see if there was any way of doing it in Excel.
Converting to a pdf file can be done but this user is not very computer savy
and to convert the workbook file and set permissions is getting a little complex for this particular user.
ASKER CERTIFIED SOLUTION
Avatar of [ fanpages ]
[ fanpages ]

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Do you want the user to be able to select the cells so that they may type in them?
If not, you could protect the worksheet (or workbook).  

All cells are locked by default.  You can allow the user to edit specific cells by selecting them, then Format>Cells>Protection Tab uncheck the lock box.

Then, go to Tools>Protection>Protect Sheet (or Protect Workbook)
Uncheck "Select Locked Cells"

Add a password if you wish (make sure you write it down somewhere!)

They will only be able to select cells that you have set up as unlocked.  If they cannot select the cells, they cannot copy them.

I hope this is a possibility for you!
Hi @bludraggin,

Even with protected cells there is nothing stopping anybody creating links to the locked content & then copying this.

For example, locking cells (and disallowing selection) in one workbook (including cell A1 on Sheet1) as you detailed above, and then creating a completely new workbook, and simply entering =[Locked_Workbook.xls]Sheet1!A1 into any cell will allow the 'copying' of the contents from the original workbook.

BFN,

fp.
Thanks for the suggestions

The problem with entering code is the way this workbook will be updated.
This workbook is created off of a master so it would be overwritten each time it was updated.
The person updates the master then deletes the data they dont want to be seen and saves the workbook
as the updated version.

I think the only way to have this done is by using a 3d party program.
or
what I would do is tell the people that have access that if they print this workbook out they will
be in BIG trouble.

Re: 'Overwriting' the file.

Surely you would just put the VBA code in the 'master' so that you always send out a copy with code within it...
We are going to try something different.
 I will start a new question if another question arises but we are scrapping this
excell spreadshhet.

Thanks anyway for the input.
Hi again,

Sorry we weren't much use [unless, of course we were!?!].

BFN,

fp.