Yesterday I wrote a simple formatting macro and then was happily able to copy it and edit it to make new versions (for different filtering/sorting) for different tabs in the same workbook.
This morning I've gone to do the same but now can't edit or copy etc - all the buttons are greyed out apart from 'run' and 'stepinto'.
Why, oh, why???
I need to use the same macro for a number of tabs, but with slightly different filters, so don't really want to re-write it each time.
Morning.
Yesterday I wrote a simple formatting macro and then was happily able to copy it and edit it to make new versions (for different filtering/sorting) for different tabs in the same workbook.
This morning I've gone to do the same but now can't edit or copy etc - all the buttons are greyed out apart from 'run' and 'stepinto'.
Why, oh, why???
I need to use the same macro for a number of tabs, but with slightly different filters, so don't really want to re-write it each time.
Any ideas?