Excel to pdf while keeping macros

[Albie]

I have an excel document that is has about 15 sheets, I would like to create a pdf for each sheet. The problem i have is that when I go to do this, I lose the bookmarks I have set up. Is there any way to stop this from happening?

 

[CalcSux78]

If you're using something to this effect:

With ActiveSheet
        .ExportAsFixedFormat _
                Type:=xlTypePDF, _
                FileName:=strscriptPath & FileName & ".pdf", _
                OpenAfterPublish:=False
    End With

... it's basically printing to a pdf file so you would lose any hyperlinks. I would think you would need a 3rd party application to handle the export to preserve links.