GL Journal Upload (PUM 54) - one workbook to include macros
We’re testing the latest journal upload process where all of the supplemental files are included in a single workbook, and we’ve run into a couple of questions.
Each time we upload a journal, the workbook automatically protects the worksheets. Because of that, we can’t easily navigate back from the Journal Log worksheet to the Journal Upload worksheet. We can work around it, but it feels like it could lead to a lot of questions from users and require some fairly significant change management. Unprotecting the sheets may help, but we're concerned that could introduce additional risk.
Has anyone else run into this? If so, what approach or workaround have you found that works well?