Excel Macro, no button "Use Relative References"

I have Excel for Mac ver 16.16.2 ;
When I make a Macro, no button "Use Relative References" appear. The code looks like relative but acts like absolute.
How can I get relative references in the macro?

Hi Sten,

Thanks for the query.

We would like you to understand that the feature is removed from Office 2016 for Mac. In our Excel for Mac User Voice, we have received many votes to request to bring back the feature. We welcome and encourage you to also vote for it.It is the best way to let the related team learn your user experience to make Excel better for you and others.


1 person was helped by this reply


Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.


Question Info

Last updated July 26, 2020 Views 335 Applies to: