Excel 2007 Print Preview button disabled

C

Corey

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

Corey

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?


It's not disabled for me.

Is it disabled for all workbooks for you?
 
D

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

Jim Rech

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

ActiveSheet.PrintOut Preview:=True

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print (physical or pdf) not respecting format of source document 0
Publisher adding blank page when printing my booklet... 2
Print order of TriFold - Publisher 365 0
Office 2010, background images do not appear in print preview nor print 0
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Office 2007 Apps - Printing all graphics mirrored - Text Normal 0
Excel 2007 Print Preview 7
Page numbering with Merged Document and IF statements 1

Top