I have a protected worksheet that needs to run every day, but the scheduler needs to have the report unprotected to run.
I've searched on this site for help, and found a vba sample. I haven't done vba's, so I'm not sure of my solution. The vba solution on this site implies that you create a button on the report to run it. Would this work with the scheduler?
Can anyone confirm this is the right solution, provide a different solution or if VBA is my solution, a little how-to to get me started?
Thank you!
I'm using Jet 9.1, NAV 5.1, Excel 2007 (but needs to open in Excel 2003) and Windows XP SP3.
Date
Votes
1 comment
-
Jet Reports Historic Posts I'm not quite sure what VBA method you're referring to….. I have desinged a few VBA Macro buttons on my reports that when clicked, asks the user for any options if they need to be updated, then runs the reports. This method does work on protected sheets, however, that method wouldn't necessarily work with Scheduler. If you design a "report" button through VBA, then the user receiving this report would need to hit that button to run and update the jet report and the data, meaning they will need to have Jet Reports installed on thier computer with "viewer" rights. And if each user is updating the report, then that gets rid of the need to have the Scheduler send the report on a regular basis since the user updates it locally on their computer.
I guess my question is, why is your sheet protected? If you just don't want the user to be able to change any data in the report, etc, use the "Auto+Hide+Lock" function in cell A1 on your report. That will lock the report so nothing can be changed once it is e-mailed through Scheduler; however, if the person receiving the report has "design" permission, he would be able to go into design mode and change the report.
There may be some other methods of sending the report in different formats other than excel (html, etc) if the above doesn't work. Let me know.
Thanks,
Scott
Hammond, Indiana
Please sign in to leave a comment.