VBA error 1004
 

I just changed my settings to open the workbook within MSIE and I couldn't do a
print|preview manually. (Print worked ok, though.)

There was no Print Preview under the File menu.

If I showed the standard (excel) toolbar, when I clicked on the print preview
icon, nothing happened.

I don't like opening excel files within MSIE, but it sure doesn't look like
print preview is supported.

===
A workaround would be not to ever open excel files in MSIE (my favorite!):

There's a setting in Windows that you can change.

In win98, I can do this:
Start Windows Explorer
View|Folder Options
File Types Tab
scroll down to MS Excel Worksheet
Select it
click the edit button
There's an option to "browse in same window". Uncheck it.

That's where you can toggle the "confirm open after download", too.

How to Configure Internet Explorer to Open Office
Documents in the Appropriate Office Program Instead of in Internet Explorer
http://support.microsoft.com/?scid=162059


Tasha wrote:

I have a macro that should show the selected sheet(s) in print preview. The macro is

Sub Print_Click

ActiveWindow.SelectedSheets.PrintPreview

End sub

The spread sheet that contains this macro is posted on our company intranet. When I click on the button on the spreadsheet from my hard drive there is no problem. When I click on it from the intranet I get Error 1004 method 'PrintPreview' not recognized for objects 'Sheets'. The PrintOut method works either on my hard drive or on the intranet but for some reason the PrintPreview does not. Any suggestions?

TIA
Tasha

--

Dave Peterson