Click Button does not work

[Craig_Foggo]

Hi.

I have successfully created a Macro that calculates all the entries in a row by colour

I have noticed that to get the total I have to go to each cell, place my cursor in the view pain and hit return

I've created a click button and assigned the macro to the button but this does not work.

Can anyone help with what I'm doing wrong?

Thanks in advance

Craig

[Pepe Le Mokko]

Perhaps post your code? ( with code tags)

[Craig_Foggo]

Hi

Not sure what code tags are but here goes. (assuming code tags are # or [ and ]

Hopefully this helps explain what I've done

Please Login or Register  to view this content.

[Pepe Le Mokko]

If you take a moment to read forum rules you will see what code tags are.
Please add them

[Craig_Foggo]

Hi

After reading the rules I'm assuming the code tags are a# or [ and ]

Hope this is what is required.

Thanks

[Pepe Le Mokko]

Edit your post, select the code and click the #button to wrap the code with tags

[Craig_Foggo]

Excellent thank you.

[Pepe Le Mokko]

You're welcome

[Craig_Foggo]

Code Tags added. Can anyone help please?

Thanks in advance

[torachan]

you are calling a sub and ending it immediately
remove that and call your function.

[rorya]

Ignoring that this is not an optimal approach to begin with (colours should really be used to reflect data, not as data), you should make your function volatile:

Please Login or Register  to view this content.

so that it will recalculate when the workbook does, for whatever reason. Changing a cell colour will never trigger a recalculation, but once the function is volatile, pressing f9 should recalculate it.