Copyin text only...not borders or shading

L

LS

I'm currently using Excel 2003 and have created several templates with hidden
formulas, shaded cells, and borders. I would like the user to be able to copy
the text in the cells without copying the border or shaded color. Is this
possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select text of a particular shading color (VBA macro) 5
How do I convert shading to highlighting for specific colors 8
How to paste this down? 3
Conditional Formatting Formula 2
Need Help Creating a Word 2010 Chistmas Letter Template 8
I can't delete shading without deleting cell borders 1
Can't delete shading from table without deleting border lines 1
freeze borders and shading 2

Top