Use this macro to freeze all the sheets in the active workbook.Before you run the macro, select a cell, row or column, below and to the right of the area that you want frozen.Field Append Text("Subject", st Subject) 'The can be used if You want to add a message into the created document.Comments: The technique used here can also be applied for inserting charts as part of the body.PS: This is a revised version of almost 5 year old article – Select & show one chart from many.
Be sure to enable macros when you open the workbook, if you want to test the macros.
Officially Dialogs are a part of the Power Point object model.
We make use of some undocumented stuff to make it work.
The native table shape is supported only with Power Point version 2000 and above.
Required: Power Point 97 or later Manipulate hidden Dialog object to display the common dialogs.