MACRO DON'T WORK

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Russell Hauf

MrExcel MVP
Joined
Feb 10, 2002
Messages
1,611
Worked right away for me. Are you sure you put the code in the worksheet's code module and not in a regular module? To view the worksheet's code module, right-click on the sheet's tab, and select "View Code". Then paste in the macro from the page you refer to (by the way, you left off a "p" at the end of the link).

HTH,

Russell
This message was edited by Russell Hauf on 2002-08-30 09:43
 

verluc

Well-known Member
Joined
Mar 1, 2002
Messages
1,451
On 2002-08-30 09:42, Russell Hauf wrote:
Worked right away for me. Are you sure you put the code in the worksheet's code module and not in a regular module? To view the worksheet's code module, right-click on the sheet's tab, and select "View Code". Then paste in the macro from the page you refer to (by the way, you left off a "p" at the end of the link).

HTH,

Russell
This message was edited by Russell Hauf on 2002-08-30 09:43
Sorry, I have done what you wrote.It doesn't
work to me.
I see change the pointer but no colours.
Any idea?
Thanks
 

verluc

Well-known Member
Joined
Mar 1, 2002
Messages
1,451
On 2002-08-30 11:22, verluc wrote:
On 2002-08-30 09:42, Russell Hauf wrote:
Worked right away for me. Are you sure you put the code in the worksheet's code module and not in a regular module? To view the worksheet's code module, right-click on the sheet's tab, and select "View Code". Then paste in the macro from the page you refer to (by the way, you left off a "p" at the end of the link).

HTH,

Russell
This message was edited by Russell Hauf on 2002-08-30 09:43
Sorry, I have done what you wrote.It doesn't
work to me.
I see change the pointer but no colours.
Any idea?
Thanks
 

Ivan F Moala

MrExcel MVP
Joined
Feb 10, 2002
Messages
4,209

ADVERTISEMENT

[/quote]
Sorry, I have done what you wrote.It doesn't
work to me.
I see change the pointer but no colours.
Any idea?
Thanks
[/quote]

The pointer changes ?? But no colours ?
The workbook you sent worked for me...I wonder if it is something else...Long shot
try changing the mouse if possible
 

verluc

Well-known Member
Joined
Mar 1, 2002
Messages
1,451
On 2002-08-31 00:12, Ivan F Moala wrote:
Sorry, I have done what you wrote.It doesn't
work to me.
I see change the pointer but no colours.
Any idea?
Thanks
[/quote]

The pointer changes ?? But no colours ?
The workbook you sent worked for me...I wonder if it is something else...Long shot
try changing the mouse if possible

[/quote]
Hi Excel friend,

A last try.
I open a new workbook.In this new workbook I copied your macro in the sheet1 module.
Then I return to sheet1 and this sheet is blanco.Must your macro then already work or have I to fill in something in that sheet?
Thanks.
 

verluc

Well-known Member
Joined
Mar 1, 2002
Messages
1,451

ADVERTISEMENT

On 2002-08-31 00:12, Ivan F Moala wrote:
Sorry, I have done what you wrote.It doesn't
work to me.
I see change the pointer but no colours.
Any idea?
Thanks
[/quote]

The pointer changes ?? But no colours ?
The workbook you sent worked for me...I wonder if it is something else...Long shot
try changing the mouse if possible

[/quote]
Hi Excel friend,

A last try.
I open a new workbook.In this new workbook I copied your macro in the sheet1 module.
Then I return to sheet1 and this sheet is blanco.Must your macro then already work or have I to fill in something in that sheet?
Thanks.
 

Tom Morales

Board Regular
Joined
Feb 16, 2002
Messages
91
Ever since we got Office 2000 at work, a common problem has be the default security settings (ie, "HIGH") that disables all macros. I've gotten many panic phone calls that have been solved by a security reset to "LOW". Have you checked that?
Tom
PS - the code worked for me. Cool code.
PPS - Ivan, at the risk of sounding picky, it'll highlight multiple rows, but not multiple columns. Will there be a version 1.1?


_________________
This message was edited by Tom Morales on 2002-08-31 10:29
 

verluc

Well-known Member
Joined
Mar 1, 2002
Messages
1,451
On 2002-08-31 03:07, verluc wrote:
On 2002-08-31 00:12, Ivan F Moala wrote:
Sorry, I have done what you wrote.It doesn't
work to me.
I see change the pointer but no colours.
Any idea?
Thanks

The pointer changes ?? But no colours ?
The workbook you sent worked for me...I wonder if it is something else...Long shot
try changing the mouse if possible

[/quote]
Hi Excel friend,

A last try.
I open a new workbook.In this new workbook I copied your macro in the sheet1 module.
Then I return to sheet1 and this sheet is blanco.Must your macro then already work or have I to fill in something in that sheet?
Thanks.
[/quote]
Hi Ivan,

By testing above,I have found that,when I look to the active cell,in the menu-bar, the conditionel formatting gives me the right colour.Can that maybe a set to found a solution?
Thanks
 

verluc

Well-known Member
Joined
Mar 1, 2002
Messages
1,451
On 2002-09-01 03:38, verluc wrote:
On 2002-08-31 03:07, verluc wrote:
On 2002-08-31 00:12, Ivan F Moala wrote:
Sorry, I have done what you wrote.It doesn't
work to me.
I see change the pointer but no colours.
Any idea?
Thanks

The pointer changes ?? But no colours ?
The workbook you sent worked for me...I wonder if it is something else...Long shot
try changing the mouse if possible
Hi Excel friend,

A last try.
I open a new workbook.In this new workbook I copied your macro in the sheet1 module.
Then I return to sheet1 and this sheet is blanco.Must your macro then already work or have I to fill in something in that sheet?
Thanks.
[/quote]
Hi Ivan,

By testing above,I have found that,when I look to the active cell,in the menu-bar, the conditionel formatting gives me the right colour.Can that maybe a set to found a solution?
Thanks
[/quote]
Someone have any idea?
 

Forum statistics

Threads
1,143,925
Messages
5,721,562
Members
422,372
Latest member
RoyRodger

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
Top