Relative Reference in a Macro
DRH,
When you click "Record" a toolbar named "Stop recording" should appear. It
is usually a floating bar with the "stop" button, along with the relative
references button.
Try running this macro to re-eanble it. Never close it by clicking the X at
its upper right.
With Application.CommandBars("Stop Recording")
.Enabled = True
.Visible = True
End With
HTH,
Bernie
MS Excel MVP
"DRH" wrote in message
...
The Help on Macro says: "8. If you want the macro to run
relative to the position of the active cell, record it
using relative cell references. On the Stop Recording
toolbar, click Relative Reference so that it is selected.
Excel will continue to record macros with relative
references until you quit Excel or until you click Relative
Reference again, so that it is not selected."
However, when I click Stop Recording, the action is
immediate (i.e.: no tool bar appears.) I can't determine
how to invoke the Relative Reference feature.
I must be missing something "obvious."
Help?
|