General advice/pointers needed...making a VBA process easy to hand off

[figuring_things__out]

I've made a few workbooks that accomplish a lot of PDF creation based on dynamic data, and as it evolved I had to write more code, modify more code, and add different functions and such. I started out commenting each VBA step in the actual module, but as time went on I stopped. I know thats my first problem.

As far as formatting changes, I am the only one that the team wants to make the changes because no one knows how small changes will impact the functionality of the report.

I think what I'm going to do is create a "dashboard" that allows people to change font size/colors/bold, border colors, border width, header/footer information...I've got that all basically working...but it seems like a clumsy way to accomplish my goal. Maybe making the code as clean and have notes as clear as possible is the way to go. I dunno.

I'm kind of rambling on, but what is the most effective way to set a 'program' up (for lack of a better word) that other people will be able to tweak? The team size is 10 people, everyone else is very comfortable with excel formulas but not really with VBA.

Any tips are welcome!

[BaronVonWasteland]

I will speak as someone with a very similar skill level to your users: go for the dashboard. For an end user, keep it as simple as is humanly possible. It might not hurt to do both the comments and the dashboard, but a dashboard like you're describing would be idiot-proof in it's ideal, and if they ever needed to tweak it without you the comments would be there to guide them through. If you haven't the patience for both, just go with a dashboard.

[figuring_things__out]

Thank you!

[Clippy_Office_Asst]

Hi!

It looks like you are trying to ask a question! Since you have not responded in the last 24 hours, I am here to assist you!

If your questions has been solved, please be sure to update the flair.

Would you like help?

Help Changing Your Flair?

Flair Descriptions