I have a macro that is pulling information from many different tabs in a work book that I need to print daily. But on row A I have a button that I press to populate the chart. Is there a way I can set it to ignore row A? And not have to be constantly adjusting the print area? Thanks for the help in advance!
You can change red line...
Please Login or Register to view this content.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
I get a compile error on the first line and it highlights "false".
If it's only the button you don't want to see when printing then you can set the Print Object format to unchecked. Right click button/shape and Format. Uncheck Print object on Properties tab.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks