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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
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
 
Upvote 0
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]
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,217,346
Messages
6,136,042
Members
449,981
Latest member
kjd513

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
Back
Top