Simple Macro Problems

markm

New Member
Joined
Jun 19, 2002
Messages
7
I have two simple macro problems -

First, when I record a macro, the small box that used to appear in the middle of the screen allowing me to stop recoding doesn't appear anymore. How can I get it to appear?

Second, say I want to record a simple macro that selects the column containing the active cell and format the column to bold. When recording the macro, the active cell happens to be A1. When I run the macro,it selects column A rather that the column containing the active cell. I think it has something to do with relative versus absolute references. Please help.
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
On 2002-09-16 04:52, markm wrote:
I have two simple macro problems -

First, when I record a macro, the small box that used to appear in the middle of the screen allowing me to stop recoding doesn't appear anymore. How can I get it to appear?

Second, say I want to record a simple macro that selects the column containing the active cell and format the column to bold. When recording the macro, the active cell happens to be A1. When I run the macro,it selects column A rather that the column containing the active cell. I think it has something to do with relative versus absolute references. Please help.

Hi markm,

First: Is there a line in one of your macro's that says: Application.CommandBars("Stop Recording").Visible = False ?

Second: What else do you expect when A1 is active?
This message was edited by rikrak on 2002-09-16 05:00
 
Upvote 0
I want the macro to select whatever column contains the active cell at the time I run the macro. This may not always be column A.

Regarding the stop recording button, I could not find the line of code you decribed.
 
Upvote 0
First:
Did you close the small box with the "X" in the right corner?

Second:
use ActiveCell.EntireColumn.Select to select column of activecell
 
Upvote 0
First:
anyway. With the right mouseclick on any toolbar, select "customize". Select the "toolbar" tab. Select "stop macro recording" (or something like that). The toolbar will display
 
Upvote 0
Assuming that I unintentionally closed the stop recording box by clicking the "X", is there a way to have the box reappear when I reord a new macro?

Your suggestion did bring up the stop recording and relative reference buttons in the toolbar, but they stay there even when I am not recording a macro.

I figured out my second problem - I had failed to click on "relative reference" when I recorded the macro. When I re-recorded it using relative references, it worked.

Thanks for your help.
 
Upvote 0

Forum statistics

Threads
1,223,493
Messages
6,172,602
Members
452,466
Latest member
Lynlindsay

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top