Target address query

[inq80]

Hello,

I've been making some custom buttons in a worksheet using shapes and they are all working nicely for what i need them to do;however after looking at the code i thought it would be simpler to do it another way and it doesn't seem to work. So I'm curious to see if someone could explain why?

I've got a practice set up at the moment with 4 cells, but the main one will be 12 once done.

It cell has been named as cell title + "Bg", so for example, the cell with "workflow" in it is named "workflowBg"

It cell then has a shape on top on it where the fill and outline are zero and is in turn called the cell title + "Btn" ( using above example that makes it "workflowBtn")

These 4 cells in the practice sheet are then collectively named "dbButtons". I've then attached the following marco to the buttons;

Please Login or Register  to view this content.

It works fine. The cell pressed changes colour when clicked.

The marco clears all the cell colours when clicked and changes just the choosen cell.

My query is that i thought it would be better to have simply two lines; one to remove the colour from all the cells when clicked & and another to add it back to the chosen cell only. That way I would have to cycle through 12 case statements when i come to add all the other buttons.

Would this be possible? i get a lot of error messages each time i try...

Thanks

[ranman256]

have 2 routines, 1 clear, 1 color.
usage:
NoColor Range("dbButtons")
or
Colorize Range("bgClaims")

Please Login or Register  to view this content.

[inq80]

Hi Ranman,

Would that work? I never considered two routines.

I could certain have one routine to clear the colour of the whole group. I assume once complete i would have to "call" the second routine to put the colour back into the cell that was clicked only.

I got stuck on the above code on being able to reference the clicked cell only. Do you know how i would do this at all?

thanks

[ranman256]

Colorize activecell