You could do this by using VBA. Create a small Sub with code like this:
Private Sub Refresh_Data
ActiveSheet.Unprotect
Application.Run "JetMenu", "Report"
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub
Assign this Macro to a button labeled "Refresh data".
Date
Votes
1 comment
-
Jet Reports Historic Posts We have created budget worksheets and would like the total row and column to be protected from input. However when we try to protect the worksheet thru excel, then when we run the report, it wants the password, which unprotects the sheet. What can we do.
USine excel 2007 and jet report 9 ver 10103
Please sign in to leave a comment.