How can I allow users to print a locked worksheet
 

Is there a way of locking a spreadsheet so that users can't change the data
but can still print the sheet ?

How can I allow users to print a locked worksheet
 

Go to the Tools menu, choose Protection, then Protect Sheet, and assign it a
password.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"Koslover" wrote in message
...
Is there a way of locking a spreadsheet so that users can't change the
data
but can still print the sheet ?

How can I allow users to print a locked worksheet
 

ToolsOptionsProtect WorkSheet will prevent entering data but still allow
printing.


Gord Dibben MS Excel MVP

On Tue, 23 Jan 2007 15:03:01 -0800, Koslover
wrote:

Is there a way of locking a spreadsheet so that users can't change the data
but can still print the sheet ?