VBA excel programming

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The macro button does not have the Absolute and Relative Reference feature on
it. What shall I do to overcome it?
 
It is on the stop recording toolbar. If that is what you mean and you say
it isn't there (there should be two, the right one is the Absolute/Relative
Toggle), then go to Tools=>Customize, first tab, Select Stop Recording and
hit the Reset button.
 
Thank you Tom Ogilvy for your advice. I played around with the macro button
and found answer. Actually on my VB toolbar there is only a blue button that
acts as a record and stop recording macro button. When I click the stop
recording button(the same blue button) then right click again, there is
scroll down menu list and on it there is stop recording message item. I right
click this stop recording item and a Stop Recording toolbar pop up. In this
toolbar I found the Relative Reference button. Great! Thanks again.
VBANewcomer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top