View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JenniferLee JenniferLee is offline
external usenet poster
 
Posts: 2
Default Print Worksheets in Reverse Order

A user has a number of workbooks that were set up adding a new sheet for each
new time period, be it a day, month, week, year, etc. So, in one example,
Sheet 1 would be January, Sheet 2 would be February, and so on. They want to
easily print all the sheets in the workbook in reverse sheet order, so that
December (Sheet 12) is on top and January (Sheet 1) is on the bottom. I
cannot find a way to do this in Excel, and their printer does not have a
reverse printing option. Is there any way to do this short of a macro (and
for that matter, can it even be done in a macro?).
Many thanks in advance for any assistance.