Please insert a Command Button by clicking Developer > Insert > Command Button (ActiveX Control). Here I create this folder in my local disc (C:).Ģ. Firstly, you need to create a folder named PDF for saving your new converted PDF file. You can run the following VBA code to save an active worksheet as PDF file by clicking on a Command Button. Use Command Button to save active worksheet as PDF file with VBA codeĮasily save active or each worksheet as individual PDF file with Kutools for Excel And if you also want to save a range or each worksheet in active workbook as individual PDF file, this article can also help you. In this article, you can learn how to save active worksheet as PDF file with VBA code through a Command Button. While working in Microsoft Excel, you may face the problem of saving active worksheet as PDF file. How to use Command Button to save active worksheet as PDF file in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |