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 ToolsMacroMacros
Select a macro, click Run

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


Louise wrote:
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" wrote:


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

Gord Dibben wrote:

Thanks Debra.

Also answered my question.


Gord

On Tue, 17 May 2005 13:35:22 -0400, Debra Dalgleish
wrote:



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

Louise wrote:


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

Thank you.

Louise


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html