I need a custom macro for Excel 2007 with a ribbon command button to activate the macro.
When the user selects a table in a file, they can click on the macro button and the selected table will be viewed in print preview with the whole table fitt to 1 page wide x 1 page tall.
An acceptable alternative is for any range of selected cells the user chooses to go to print preview and fit to 1 page wide x 1 page tall.
1. The VBA code (in Word or notepad or whatever you prefer) for the macro that must go in an XLAM or XLA file--I need to create the file on my computer for and will then copy the code over
2. accompanying instructions on how to insert the ribbon button which will activate the macro
23 freelancers are bidding on average $263 for this job
I am an Expert of Excel 2007 Macros, and I can do t within few hours (So Please select my bid only, because I have maximum Experience, my bid price is lowest and delivery time will be fastest)
I have writing Excel macros since 1996. I could complete this in a couple of days and instruct you how to include the command button on the tool bar all for less than 250