This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
I created a page setup tool (form macro) to automatically apply print formatting to one/all the sheets in an Excel document. I mentioned it in another thread, and several people expressed interest, so I thought I'd share it.
You can open the tool by pressing Ctrl Shift P with the workbook open. I built this at my old company maybe 6 years ago, and a lot of the defaults were tailored to what we were using at the time, so you might want to go into the code and change those. I kept this saved with a handful of other (more niche) tools in my PERSONAL.XLSB workbook. If this is useful to you, then I'd suggest you do the same (can find instructions online on how to create a PERSONAL.XLSB that always opens when you open Excel if you don't know how).
Post Details
- Posted
- 4 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/excel/comme...