View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lostguy Lostguy is offline
external usenet poster
 
Posts: 15
Default Report of Margins and Worksheet Setup?

Hello!

Any code out there to loop through all the sheets in a workbook and
give a report (MsgBox, etc.) of how each sheet is setup (values of
left/right/top/bottom margins, top/bottom headers, center on page hor/
vert, adjust to x% or fit to x page by x page)?

My workbooks have many tabs and going through each and verifying this
is taking awhile.

Any help appreciated!

VR/

Lost