Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Runtime error '1004' General ODBC error | New Users to Excel | |||
Excel 2003 Macro Error - Runtime error 1004 | Excel Discussion (Misc queries) | |||
Error 1004 | Excel Programming | |||
VBA error - run-time error '1004': | Excel Programming |