Float button on current row

[vabtroni]

Greetings everyone.

I have a button called "but_ENV_AVARIAS" wich runs a macro, and I need it to float on the current selected row near column I (with a fixed horizontal position), except if:
- current row is above row 8
- current row is below row 30007
...meaning, if selected row is not between rows 8 and 30007, I would like that button to become invisible.

Is there any chance I could put it on VBA?

Best regards,
Vasco.

 

[vabtroni]

...and if I select column I outside the range 8-3007, it returns the same error, highlighting the line:

ActiveSheet.Shapes.Range("but_ENV_AVARIAS").Visible = False

 

[vabtroni]

So did my script in post #7 not work for you???
You need to select a cell in column "I"

The error was returned when I selected column "I"

 

[vabtroni]

Your script is returning runtime error 1004 whenever the is set to be visible or invisible, I believe.

 

[vabtroni]

Your script is returning runtime error 1004 whenever the button is set to be visible or invisible, I believe.

 

[My Aswer Is This]

...and if I select column I outside the range 8-3007, it returns the same error, highlighting the line:

ActiveSheet.Shapes.Range("but_ENV_AVARIAS").Visible = False

Did the script work when inside the range?

Is this the proper name of the button? "but_ENV_AVARIAS"

Do you have any other sheet event scripts in this sheet?
If so show them to me

 

[My Aswer Is This]

I suspect you shape is not named:"but_ENV_AVARIAS"

 

[My Aswer Is This]

You said in post 1
I have a button called "but_ENV_AVARIAS"

 

[vabtroni]

Did the script work when inside the range?

Is this the proper name of the button? "but_ENV_AVARIAS"

Do you have any other sheet event scripts in this sheet?
If so show them to me

Yes, it recognizes the range.

Yes, it is the proper name of the button.

No other event scripts in this sheet

 

[My Aswer Is This]

So tell me what is it doing or not doing.
Is it working inside the range?

You started off saying it did not work outside the range and never said if it works inside the range.

Are using a "Apple" computer?
What version of Excel?

Yes, it recognizes the range.

Yes, it is the proper name of the button.

No other event scripts in this sheet

 

[vabtroni]

So tell me what is it doing or not doing.
Is it working inside the range?

You started off saying it did not work outside the range and never said if it works inside the range.

Are using a "Apple" computer?
What version of Excel?

I am so so sorry, I mislead you!!! I was wrong in one thing, there was a mistake on the name of the object.

Your script is WORKING oh so fine!!!!

Thank you in advance, but now I'd like to ask you something: is there a way to "tune" it a little better to these conditions:
- instead of working only in the "I:I" range, I'd like it to work on range "A:K", I mean, whenever I select any cell on the row, the button is allways placed on this same current row, but next to column "I", no matter what column I have selected on the current row.

Thank you so so much!!!!