Hi
I've tried searching to find the solution to this but cant seem to find anyone having this problem before. Seems like its something obvious I'm missing but cant work out what it is!
I'm using the code below to automate the process of printing 3 hidden sheets of a workbook. The content is a lot of financial stuff and there are a lot of '£' signs involved but when using the macro to print, all '£' signs are printed as '$' signs. When printing normally through the menu system in Excel this doesn't happen and all is printed correctly. I've tried on different computers with different printers and the same thing happens.
I'm on an iMac with High Sierra running Excel 2016 version 15.39.
VBA Code:
Many thanks
Pete
Bookmarks