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....

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

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

I ran the same line from code and the print button was enabled.

Did you try that same line of code on a new worksheet in a new workbook?

I don't really have a guess. I know that the ribbom can be customized, but I'm
not sure how (or if) the print preview ribbon can be changed.

Corey wrote:

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

--

Dave Peterson

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
|
|