| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print and save as restriction
Possible to prevent user from printing and save as
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print and save as restriction
Besides making the file readonly (which doesn't prevent SaveAs)
If they disable macros, then no. If they don't, use the beforeprint and beforesave events. Lock all cells, protect all sheets and don't allow selecting (but they can still take a snapshot). -- Regards, Tom Ogilvy "crapit" wrote: Possible to prevent user from printing and save as |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print and save as restriction
Oh, which mean disable macro allow all normal function
"Tom Ogilvy" wrote in message ... Besides making the file readonly (which doesn't prevent SaveAs) If they disable macros, then no. If they don't, use the beforeprint and beforesave events. Lock all cells, protect all sheets and don't allow selecting (but they can still take a snapshot). -- Regards, Tom Ogilvy "crapit" wrote: Possible to prevent user from printing and save as |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save as PDF not same size as Print and Print Preview in Excel | Excel Discussion (Misc queries) | |||
| How to get rid of print preview restriction?! | Excel Discussion (Misc queries) | |||
| Save-As Restriction | Excel Worksheet Functions | |||
| Save, Save As, Print Grayed Out when instance created via VBA/VB6 | Excel Programming | |||
| Save, Save As, Print Grayed Out when instance created via VBA/VB6 | Excel Programming | |||
![crapit[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
