PDA

View Full Version : Printing $ instead of £



huzz456
10-23-2017, 03:13 AM
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 pointed 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:

Sub PrintAll()


Application.ScreenUpdating = False
Sheets("Print Version").Visible = True
Sheets("Print Version").PrintOut
Sheets("Print Version").Visible = False


Sheets("Manager's Copy").Visible = True
Sheets("Manager's Copy").PrintOut
Sheets("Manager's Copy").Visible = False


Sheets("Weekly Return").Visible = True
Sheets("Weekly Return").PrintOut
Sheets("Weekly Return").Visible = False
Application.ScreenUpdating = True




End Sub



Many thanks

Pete

huzz456
10-23-2017, 11:41 PM
Sorry, just realised I should have put the code like this but can't seem to edit my original post now


Sub PrintAll()

Application.ScreenUpdating = False
Sheets("Print Version").Visible = True
Sheets("Print Version").PrintOut
Sheets("Print Version").Visible = False

Sheets("Manager's Copy").Visible = True
Sheets("Manager's Copy").PrintOut
Sheets("Manager's Copy").Visible = False

Sheets("Weekly Return").Visible = True
Sheets("Weekly Return").PrintOut
Sheets("Weekly Return").Visible = False
Application.ScreenUpdating = True

End Sub