I am trying to record a macro to run a report.
I have mapped out the keystrokes to get to the actual report and when I am recording all seems fine.
However, after I save the macro and try to run it, the macro navigates to the report in the list but it is a light grey instead of a dark grey. So when I hit the space bar nothing happens because that report is not active.
Does anyone have any idea why this is happening and have a way to make it work?