| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why doesn't my Excel worksheet print like it looks on the screen? | Excel Discussion (Misc queries) | |||
| How do I print an excel worksheet that contains a form. | Excel Discussion (Misc queries) | |||
| Worksheet locked for editing | New Users to Excel | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| How do I print a worksheet containing a watermark? | Excel Discussion (Misc queries) | |||
Linear Mode
