code to print in color
Hi there,
I'd like to create a button in excel that users can click to print out 16 copies of the active sheet in grayscale and 1 in color. I found many macro's on the web that claim to do something like this, mostly by using the .BlackAndWhite or ColorMode properties, but the version of excel I'm using doesn't seem to know these properties. Does anyone know a different code to get this done? Thanks in advance.
Hello WCJanssen,
Which type of computer are you using PC or Mac? What version of Excel are you running on this computer? What make and model of printer are you using? All these questions can influence the answer to your question.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks