$$Excel-Macros$$ Message Box to Show ActiveSheet.PageSetup.Orientation

I need to trap PageSetup settings to determine if the active worksheet can be printed programmatically. (Note that I'm not asking how to change them - if they are not within reason, the active sheet will not be printed.) I thought the following line of code would result in "xlPortrait" or "xlH

$$Excel-Macros$$ Excel 2007 "Custom Toolbars Button"

There is a "Custom Toolbars Button" available for the "Quick Access Toolbar". This button has "drop-down" capability, so I assume commands can be added to this button. Can anyone point me to an example of how this button can be used - my web searches have pinpointed no results. -- -

$$Excel-Macros$$ Excel 2007 Change Default Table Styles

Excel 2007 applies a table style to a new table, for example when data is pasted from an Access Database or a summary cell in a pivot table is double clicked. I don't want to use extra toner to print the applied shading, and I don't want to change the style every time I create a new table. Can th

$$Excel-Macros$$ Create Formula to Total Certain Cells

I have a spreadsheet: Account Amount a.120 100.00 b.120 50.00 Tot 120 150.00 a.220 75.00 b.220 25.00 Tot 220 100.00 Etc I want to create a formula at the bottom that adds all lines which begin with "Tot". I need the actual formula not jus