Making Command Button Flash Colors

[000]

Is there any way when a spreadsheet is opened for a command button to flash red continually until it is clicked?

Thanks

 

[GlennUK]

If I did that to my users they would not be happy. Can you say why you want to do this?

 

[Ruddles]

Is there any way when a spreadsheet is opened for a command button to flash red continually until it is clicked?

1) Please don't.

2) If you just want your users to click the button so some piece of code can run, why not just run the code? Why insist on the button being clicked.

3) No, really - please don't!

 

[000]

I was just trying to get the users attention and prompt them to click the button.

 

[GlennUK]

I was just trying to get the users attention and prompt them to click the button.

... again I ask, why? Why do they have to press the button when the workbook is opened????

 

[000]

The command button runs code that goes through and hides rows that have "NO" or "0" in any of the cells. Would it be a real hassle to get it to flash? I dont need it to, I just thought it would be cool if it could.

 

[Ruddles]

... again I ask, why? Why do they have to press the button when the workbook is opened????

Yes - just run the code.