+ Reply to Thread
Results 1 to 3 of 3

Printing $ instead of £

  1. #1
    Registered User
    Join Date
    10-23-2017
    Location
    UK
    MS-Off Ver
    Mac Excel 2016
    Posts
    2

    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 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:

    Please Login or Register  to view this content.


    Many thanks

    Pete
    Last edited by huzz456; 10-24-2017 at 02:34 AM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Printing $ instead of £

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    10-23-2017
    Location
    UK
    MS-Off Ver
    Mac Excel 2016
    Posts
    2

    Re: Printing $ instead of £

    Quote Originally Posted by alansidman View Post
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

    Sorry about that, I've amended it now

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. printing page number while printing entire workbook
    By shakir1401 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-23-2015, 06:06 PM
  2. Replies: 1
    Last Post: 06-11-2014, 09:23 AM
  3. Replies: 0
    Last Post: 02-27-2014, 01:31 PM
  4. Replies: 0
    Last Post: 09-18-2013, 06:34 AM
  5. Replies: 0
    Last Post: 07-18-2012, 03:57 AM
  6. Replies: 3
    Last Post: 07-16-2012, 03:24 AM
  7. Disabling Printing ability of a sheet unless printing from a macro
    By cadamhill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-05-2012, 04:41 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1