Stop recording macro

[bozodog]

I am using Excel 365. When recording a macro to open the "custom header" the stop recording button is unavailable. Is there a way to access it or a keyboard shortcut to stop recording? Thanks

 

[JustynaMK]

Hi, try using the keyboard shortcut:
Alt + L + R
Hopefully this will help.

 

[Eric W]

Also, look at the bottom left of the Excel window. In the status bar you should see the word "Ready", followed by a black square. Click the black square to stop recording. (Hover over it with the mouse to see the help text.)

 

[bozodog]

ALt+L+R did not work for me. The black square will not stop the recording; just makes a noise. My steps are View, Macros, Record Macro. Page Layout, click the arrow at the bottom right of page layout for page setup. Then the Header/footer tab then custom header. Thank you for your replies.

 

[JustynaMK]

Hi, thanks for clarifying your steps.

You will only get access to Stop button once you close all pop-up windows, including "Page Setup" and "Header". So, once you set up your Custom Header, just apply your changes by clicking on OK, and then Stop Recording.

In fact, VBA won't record any actions that you took in "Header" window unless you actually apply it to the active sheet. You can test it yourself if you open VBA window (Alt+F11) and display both VBA and Excel windows side by side on the same screen. Then, once you start recording a macro, you will notice how new lines of codes are being added with each action you perform. You will also notice that nothing happens on VBA screen once you open the "Header" window; the code is only being added once you press "OK" and apply the changes to the existing sheet.

Let me know if that makes sense.

 

[bozodog]

That makes sense. Thanks for the replies all.

 

[JustynaMK]

You're welcome. Take care