Macro doesn't work in Excel 97

Matty2470 · Mar 11th, 2002, 08:24 AM

The following macro made for excel 2000 doesn't work in the 97 version. What do I need to change?

Sheets("Sheet2").Rows("2").ClearContents

Dave Hawley · Mar 11th, 2002, 08:28 AM

Hi

Code looks ok, so I suspect you are running the macro from an ActiveX Control. Set it's TakeFocus******* Propery to false or select any cell as the first line. If it's only to run a Procedure you should be able to use a CommandButton from the "Forms" toolbar.

Steve Hartman · Mar 11th, 2002, 08:44 AM

Also, in the VBA editor on the 97 system, check the resources menu and see if any of your resources are listed as MISSING. if they are, uncheck them and try to run it again.

Matty2470 · Mar 11th, 2002, 09:19 AM

HI, thanks for the help guys. Only, when you say I am running the script from an activeX property, I just set a command button and put the clearContent action in place.

I need all people on our system to be able to use this form, so I want the form to be working and self contained, not working on one computer and not on another.

You say I should set the TakeFocus******* property - this is not to a command button, but to an ActiveX Property?

Iam confused.

PLease help.

Dave Hawley · Mar 11th, 2002, 09:24 AM

Hi

I am assuming the CommandButton you are using is from the "Control toolbar"?

While in edit mode (left most icon on the control toolbar) right click on the buttom and select "Properties" then scroll down to TakeFocus******* and set it to "False". Or another way is to use:

Range("A1").Select

as the first line in your row clearing code.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 11th, 2002, 08:24 AM	#1
Matty2470 New Member Join Date: Mar 2002 Posts: 24	The following macro made for excel 2000 doesn't work in the 97 version. What do I need to change? Sheets("Sheet2").Rows("2").ClearContents

Mar 11th, 2002, 08:28 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Code looks ok, so I suspect you are running the macro from an ActiveX Control. Set it's TakeFocus******* Propery to false or select any cell as the first line. If it's only to run a Procedure you should be able to use a CommandButton from the "Forms" toolbar.

Mar 11th, 2002, 08:44 AM	#3
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Also, in the VBA editor on the 97 system, check the resources menu and see if any of your resources are listed as MISSING. if they are, uncheck them and try to run it again.

Mar 11th, 2002, 09:19 AM	#4
Matty2470 New Member Join Date: Mar 2002 Posts: 24	HI, thanks for the help guys. Only, when you say I am running the script from an activeX property, I just set a command button and put the clearContent action in place. I need all people on our system to be able to use this form, so I want the form to be working and self contained, not working on one computer and not on another. You say I should set the TakeFocus******* property - this is not to a command button, but to an ActiveX Property? Iam confused. PLease help.

Mar 11th, 2002, 09:24 AM	#5
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi I am assuming the CommandButton you are using is from the "Control toolbar"? While in edit mode (left most icon on the control toolbar) right click on the buttom and select "Properties" then scroll down to TakeFocus******* and set it to "False". Or another way is to use: Range("A1").Select as the first line in your row clearing code.