Print macro not working on Mac

[Grub88]

Hi all,
I've recently put together an excel doc on Windows with a 'print macro' that I've since discovered is not working for those who are accessing the document on a mac.
I have a handful of macro's that are used depending on which sheets need to be printed (there's a 'print friendly' version for each entry page that fits on 2pages and is black and white not all the pretty colourful stuff), but they are follow the same code

Sub Initial_Print()
' Initial_Print Macro
    
    Sheets("Initial Referral_Print").Visible = True
    Sheets("Initial Referral_Print").Select
    ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
        IgnorePrintAreas:=False
    Sheets("Initial Referral_Print").Visible = False
    Sheets("Initial Referral").Select
End Sub

Is there a way to make this work whether your using mac or windows?

Cheers,

 

[RoryA]

What exactly do you mean when you say it doesn't work on a Mac? What happens?

 

[Grub88]

I'm not 100% sure as I don't have a Mac or anyone near me with one to try it. The feedback I've been given (as it's a form developed to be used across our region) is that it's a generic error message. I'm waiting to get further information as to what it is/if there is a code or number to go with it.
They are also unable to open PDF files that I have embedded using the 'insert object' pathway. There have been no issues for anyone else except those using Mac.

 

[RoryA]

If you have to develop something to work on a Mac and you don't have one available to test with, I wish you the best of luck. It's usually a painful process, even with the progress that has been made recently.