no. when you step from the excel enviorment to the pdf enviorment this is what you see and does not give much opportunity for modification.
Sub pdf()
'
' pdf Macro
' Macro recorded 10/18/2006 by Trial User
'
'
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End Sub
i need a code I can put into one of my macros which will
activate print (the print area has already been set)
save as pdf
name the pdf document the value (or text) of a cell on the worksheet
return to the active worksheet in excel
Right now the macro stops and I have to manually do the...
i need a code I can put into one of my macros which will
activate print (the print area has already been set)
save as pdf
name the pdf document the value (or text) of a cell on the worksheet
return to the active worksheet in excel
Right now the macro stops and I have to manually do the above.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.