Missing relative reference icon

  • Thread starter Thread starter ktmd97
  • Start date Start date
K

ktmd97

While recording a macro I clicked on the relative reference icon to
switch to absolute referencing. Now I want to go back to relative but
the icon is not visible on the toolbar!!!!

How can I make it reappear?

Thanks
 
Sub ResetStopMacro()
Application.CommandBars("stop recording").Reset
End Sub

HTH,
Bernie
MS Excel MVP
 
I am having the same problem as the original post. I tried copying the VBA
lines wrote in the previouse response in VB Editor. I tried to run and it
did not correct the problem. Am I doing something wrong?
 

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

Similar Threads

Absolute or Relative reference - no longer a choice! 5
Relative adress in recored macro 3
Absolute to Relative Referencing 3
Customize Quick Access Toolbar 5
Can't find "stop recording" toolbar to use relative references 2
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Relative Reference in a Macro 2
relative reference pivot table macro 2

Back
Top