An everything Macro. Save as PDF, in Landscape, from Cell let me choose the folder.

Hi All those way smarter than me.

i have without much success been trying to make a macro that will save the active sheet of a multi sheet workbook.
i have made this rubric for marking my students work.
on one sheet i enter numbers. these are reflected in a designed rubric on another sheet.
so when on the rubric sheet i can select a student from a dropdown list and it changes to reflect his grades.
what i am now trying to do is make a macro that then saves the rubric as a PDF in landscape format and with the save as name taken from
where i select the students name.
i have tried running a macro with no success and i am so not understanding that some of the stuff i see online i have not been able to do.
i am using Mac excel version15.22 can anyone give me some ideas as to where to start.
i have tried. any help would be a weight lifted.


Sub SavePDF()
'
' SavePDF Macro
'

'

ActiveWorkbook.SaveAsFixedFileFormat Type:=xlPDF, Filename:= _
Range("H4").Text, FileFormat _
:=xlPDF, PublishOption:=xlSheet
End Sub

Hi Kev

the value in H4 is a drop down list of student names.
when i change the student name the rubric changes and i am then able to write comments about students and then i manually go through the process of saving rubric.
first i have to go to page set up and click okay on landscape ( not sure why i have to do it each time ) then file save as PDF then select worksheet then put in students name as the save name and then direct to folder i am needing.

Hi Kev
i ran that code and got runtime errors
tried changing a few things and still no dice.
i am sure it is the mac thing.

Thank you Kev
That link was so much help and yet so teasing. It showed me that what i would like to do is capable yet i am so new to this that i dont even know the right questions to ask.
For example.
The ADDIN when i press the button it brings up the outlook new mail with the worksheet saved as using the date as the saved as name.
My issue is i want the saved as name to be taken from cell (H4). I am unable to change the ADD-IN.
So i am after VBA to open my outlook mail with the worksheet saved as (H4) and attached.
Maybe it could put the same name in the send to on the mail.