I sent you the sample file.
There is a module there named mSave2PDF, just copy this module to your file
If you want to save a particular worksheetas a PDF you just add a macro to do just that, alomost like the code in Sheet1
A macro couldb:
This macro will save the worksheet that is active at that moment to PDF.
I cannot explain more that that, if you do not yet have enough VBA knowledge then you are in for a difficult time asking this type of questions.
What do you expect? A full course of VBA?
If you clearly explain what the code is you are using now and what you want to do then maybe I can try and guide you though the steps.
But again with no VBA knowledge it will be very difficult.
Bookmarks