Made a system, the report with the method of generating Excel table, and then through the Excel print preview, print, now want to generate Excel file, to prevent the operator to modify the data, the file can print preview, print, can't do any other operations, such as modification, copy, save as, and so on, is there a way to set the PB Excel to achieve this effect?
Thank you very much!

CodePudding user response:

A,,

CodePudding user response:

If so then why bother to use excel

CodePudding user response:

The top! EXCEL should be, just like you too much trouble operation? Also EXCEL file, even if you make it so that the user to search on the net directly is cracked, do not have what meaning,
If you want to achieve their effect, or not to consider using EXCEL, find another other

CodePudding user response:

Through setting the Excel the properties of PB can let others cannot be modified, but people will Excel or can be set back, so you still want to other way

CodePudding user response:

Don't want to do that, you can check the vba for excel on set read-only and open the passwords in the excel content...

CodePudding user response:

1, do not allow modification can be done, but are not allowed to copy, save as is in trouble, such as
2, I guess may be you want to read the production file copy to others, but also to prevent others to modify, copy, etc., may use hardware equipment, if so I also have trouble, but in the end by copy U disk,

CodePudding user response:

reference 4 floor jjoulejcc response:

through setting the Excel the properties of PB can let others cannot be modified, but people will Excel or can be set back, so you still want to other way

This password is easy to break

CodePudding user response:

Consider using a PDF file

CodePudding user response:

Use the f1 controls, this can be

CodePudding user response:

Thank you, is not much, everybody pardon ah ~ ~

CodePudding user response:

Why stick to points is not successful? Do N times, it is no effect: (

CodePudding user response:

The original poster directly in PDF format is not better

CodePudding user response:

I also met the same problem, is there any way to solve it