Hi Andreas,
In order to have Jet protect a worksheet, you need to put Auto+Hide+Lock in cell A1 of the worksheet. Then when you run the report, Jet will automatically protect that sheet. As far as user input, the easiest thing to do is just have your user options on a different sheet which you reference from the locked sheet. If you really want the user to be able to edit things on the locked sheet, you can use the Stored Viewer Data feature of Jet Reports, although I'll warn you it's kind of difficult to set up correctly. There is an example report on this thread:
http://community.jetreports.com/viewtopic.php?f=13&t=68
Regards,
Hughes
Date
Votes
2 comments
-
Jet Reports Historic Posts I'm trying to protect some cells in a Jet-report worksheet, but can't get it to work.
I first choose all cells and lock them
Then I select the cells that the users should be able to change and unlock those.
Then, if I do "Protect Workbook" I get an error message when I click "Refresh": "The workbook is protected. Please unprotect the workbook before continuing."
If I do "Protect Sheet" and the click "Refresh" the protection is disabled.
How can I protect some cells in the workbook?
Regards!
Andreas Indahl -
Jet Reports Historic Posts Hi Andreas,
Depending on what you're trying to do, there may be another option open to you.
In Jet Essentials 2012 there is a new 'dashboard' mode which allows the user to change cell (or slicer) values and have any dependent queries and calcuations automically updated when the report is in 'report' mode.
To use this feature put Auto+Hide+Lock+Dashboard in cell A1 of the worksheet. This locks the entire sheet. To unlock a cell, right-click it then choose "format cell', select the 'protection' tab, and deselect the box for 'locked'. this will allow that particular cell to be used.
Attached is a very simple example (based on NAV data).
Dashboard mode cannot be used on sheets with replicators (NL rows, columns, sheets, or tables).
Steve
Please sign in to leave a comment.