How to save detail styles
I'm creating a template to be used by our PMO. Every PM will need to copy and paste information into an Excel template from time to time. Since the format needs to be universal, I was creating a macro to create the same format for the users. I can save a table and filter for left hand portion of the Resource Usage view; that works just fine. But for the right hand portion, I only want to show work.
A user might have previously added any number of detail styles and I want to make this as idiot proof as possible.
Any suggestions on how to create a macro that shows ONLY Work on the right hand side?
(my current solution is to give commands to remove every single possible style and then to add Work, but it seems to create an error)
|