Data Validation circles

[Louise]

If you have data validation circles on your worksheet, is there any way these
can be printed with the worksheet?

Thank you.

Louise

 

[Gord Dibben]

Louise

What is a "data validation circle"?


Gord Dibben Excel MVP

 

[Debra Dalgleish]

There are instructions in the following MSKB article:

XL: How to Create Data Validation Circles for Printing
http://support.microsoft.com/default.aspx?id=213773

 

[Gord Dibben]

Thanks Debra.

Also answered my question.


Gord

There are instructions in the following MSKB article:

XL: How to Create Data Validation Circles for Printing
http://support.microsoft.com/default.aspx?id=213773

 

[Debra Dalgleish]

You're welcome! I was tempted to reply to your question, "They're like
crop circles, but smaller, and more colourful," but thought the article
might be more helpful. <g>

 

[Louise]

Thanks for this. I don't have much VBA knowledge to write the macro, I might
get the felt tip pen out instead!!!

Louise

 

[Debra Dalgleish]

I'm sure you won't need the felt pen!

There are instructions here for copying the code to your workbook:

http://www.contextures.com/xlvba01.html#Regular

To run a macro, choose Tools>Macro>Macros
Select a macro, click Run

And if you get stuck, post another question here, and someone should be
able to help you.