Relative Macro icon on the Stop Macro button

PaulKazyak

New Member
Joined
Jul 29, 2007
Messages
3
For some reason I don't get the small Stop Recording menu with the option to turn the Relative or Absolute Macro function on. Therefore all my Macros run in Absolute. Did I change a setting somewhere that I am not aware of.

The Visual Basic Tool bar only gives me the Run, Start buttons/Icons, And of course after I start one the Start button changes to Stop, without any way to change the macro from relative to absolute.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

ADAMC

Well-known Member
Joined
Mar 20, 2007
Messages
1,169
Office Version
  1. 2013
Platform
  1. Windows
Hi,

See if this works

when you click record macro and the little stop button appears on the small menu, click in the top right and choose add or remove buttons, you can add the relative button back on.....

Hope this helps
 

PaulKazyak

New Member
Joined
Jul 29, 2007
Messages
3
The option to activate or add the relative option was not listed.

How does one cut and past screen shots on this bulletin board. It would probably help if I could visually show what I am seeing.

[/quote]
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,357
Office Version
  1. 365
Platform
  1. Windows
Paul

What do you mean your macros run in 'Absolute'?

Running a macro/code and recording one are different things.

If the problem is that you aren't seeing the menu then right click a toolbar and select customize.

Then select Stop Recording.
 

PaulKazyak

New Member
Joined
Jul 29, 2007
Messages
3
Ah Success!!! Crikie, I didn't realize the toggle was under the customize setting.

MANY THANKS!
PAK
 

Forum statistics

Threads
1,181,361
Messages
5,929,531
Members
436,676
Latest member
Mavri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top