Icon Sets - Copy/Paste Sheet with Icons only

[millzner]

I am using a Worksheet for creating a Report. Using the Icon Sets for for Red, Yellow, Green Dots and showing Icon Only. Working great on that Sheet. I need to distribute that section of the Worksheet to an Email Distribution List but not permitted to share the entire Workbook or the data in the cells that is creating the Icons.

When I copy and paste the Worksheet cells into the body of an Email, I lose the Icons and the Data is visible.

I can do this with pasting as Image but not favorable if there is a better way. Would prefer to paste as a Worksheet with Icons showing only.

Below is sample of my Worksheet......Can I copy and paste it just like that without data?

 

[Fluff]

I think that an image, or pdf is the only real option.

 

[millzner]

Guess I didn't think of PDF but that would be better than an image I think.......would still like a Spreadsheet version if anyone has a solution for that?

Thanks Fluff

 

[Fluff]

If you removed the data then there is nothing for the CF to work on, so you would need a macro to insert images into the sheet to replicate the icon set.