I don't understand why the Print button is disabled either but does this
code do the same thing?

ActiveSheet.PrintOut Preview:=True

--
Jim
"Corey" wrote in message
...
| Dave, It seems to be disabled for ONLY the Excel Application working on.
| If a blank sheet is created and 1 value placed in the sheet, Print Preview
used, then the option to
| Print is enabled.
| But not when run from the code.
|
| The line of VBA i use is :
| ActiveWindow.SelectedSheets.PrintPreview
|
| Any idea's?
|
|
| "Dave Peterson" wrote in message
| ...
| It's not disabled for me.
|
| Is it disabled for all workbooks for you?
|
| Corey wrote:
|
| I have code to input data into a sheet, then Print Preview the shet for
the USER to either view as
| is, or Print.
| Problem is Excel 2007 Print Preview button to PRINT the sheet is
DISABLED.
|
| How can i enable the Print Button?
|
| Corey....
|
| --
|
| Dave Peterson
|
|