Hi All,
Is there a way to add security in my workbook using jet reports only?
i have some confidential data in my jet report output, how can hide and lock those data permanently without using vba macro? because my user can easily unhide and unlock those sheet by using unhide and unprotect.
Thanks'
Denxio
No it is not possible.
Jet Professional does generate excel spreadsheets which can be 'protected' by adding the +Lock arugment to cell A1 (Auto+Hide+Lock) which will lock that page; however, the lock setting does not allow you to include a password. So any user can easily unlock the page.
If you're using the scheduler you could set the parameter to delete hidden rows / columns and sheets. But I suspect that solution would be unsatisfactory as you'd like to see the confidential information.
An alternative workflow might be to use the Option page to generate two views of the document one with unhidden confidential content. and the other with hidden confidential content and then Output them to different folders and permanently remove hidden rows columns and sheets.
