can i set up excel default to print all pages of workbook, fit to page??

[daisygirl1977]

would someone out there be able to help me figure out how use visual basic to program a special print button in excel for a colleague so that it will default to print all pages of any workbook, fit to page? I read that it can be done with a visual basic button that will show up in all workbooks. I have no idea how to go about setting it up.
thanks

 

[XLfriend777]

Hi daisygirl1977 - Welcome to the forum. It sounds like what you are trying to do is possible. We may need a little more information to be helpful. I can imagine a macro that is run saved in your Personal.xlsb file that is always accessible. Is that what you were looking for?