0
I'm working in Excel and I am about to create a macro. I record myself but the macro is not recording when I click on the menu on Excel, only the cells! How to record also the menu clicks I do?
Edin Neziri
Posted 2017-07-05T07:24:09.327
Reputation: 11
2
The macro recorder does not record all things that you click. It also very much depends on the Excel version. In Excel 2007, for example, the macro recorder did not record anything to do with charts.
You will need to find out what VBA commands do the things that you want to do and then edit the code and write the commands in manually.
teylyn
Posted 2017-07-05T07:24:09.327
Reputation: 19 551
I'm using Excel 2016 – Edin Neziri – 2017-07-05T07:44:46.680
2Glad you shared that. That does not change my answer. – teylyn – 2017-07-05T08:08:38.927
What menu action in particular are you trying to capture? – Excellll – 2017-07-06T19:18:10.470