Consulting

Results 1 to 2 of 2

Thread: Printing $ instead of £

  1. #1
    VBAX Newbie
    Joined
    Oct 2017
    Posts
    2
    Location

    Printing $ instead of £

    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

  2. #2
    VBAX Newbie
    Joined
    Oct 2017
    Posts
    2
    Location
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •