Record Macro dialog box is lost! 1

[wrk6718]

Am writing a macro with a relative reference...but when I go to Tools\Marco\Record new macro ... fill the requested info in and go to record

The dialog box doesn't appear so I can't use the relative reference selection. I am convinced it is lost.

I know how to stop recording the macro when I'm done.

None of the buttons on the Visual Basic toolbar have the relative reference button?

Many thanks again!!

 

[SkipVought]

Hi,

Do you have a SMALL FLOATING Stop Recording Toolbar?

If not, while RECORDING, right click the Toolbar and select the Stop Recording Toolbar.



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[wrk6718]

No I do not have a floating toolbar.

I understand that I can stop recording.

My problem is I need the Relative Reference button that is in the dialog box?

Any ideas?

 

[SkipVought]

right click the Toolbar and select the Stop Recording Toolbar

I am referring to the Excel Application Toolbar.

In the Stop Recording Toolbar is the Relative Reference Button.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[wrk6718]

Wow! I didn't realize that all the toolbars don't appear in the View button...Thanks again!