I have an Excel workbook with shapes that are used as macro buttons. When I use Page Setup/Fit to: 1 page wide by 1 page tall, the content of the worksheet adjusts to fit on one page but the shapes (macro buttons) print at 100%. Is there a way to set the shapes to adjust to the print scale?
Hi,
Right click on the button, Size & Properties, SizeTab > deselect Lock Aspect Ratio, Properties Tab > Move & Size with cells
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks