I am looking to make a command button that will create a PDF of sheet 1 with a file name of what’s typed in cell (I9) and stored in the same folder that the excel sheet is stored.
I tried a code that Paul made for another user but not sure its what I really need.
Please Login or Register to view this content.
That code will generate a PDF of the currently selected sheets in the workbook, with the same name as the current workbook. To use the value in I9 and print only Sheet1:
Not necessary to turn off screen updating, this code won't cause any screen updates.Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
ok I am having an issue with getting it right.
this is what I have for command button 2
Please Login or Register to view this content.
What is the issue? You need to be specific. If you are getting an error message, provide the text of the message. If you are getting unexpected behavior, describe the behavior. Also describe where is your button and where you put this code.
I tested this code in Module1 of a sample workbook and it worked, so there is some issue with your setup.
Sorry about that
the private sub commandbutton2_click() is highlighted yellow
here is the error.
Please Login or Register to view this content.
You have two Sub declarations, delete the one you don't need:
[/QUOTE]Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks