Web Page Preview

Home Search Site Map

Up
Close
Exit
File Search...
Most Frequently Used
New...
Open...
Page Setup...
Permission
Print...
Print Area
Print Preview
Properties
Save
Save As...
Save as Web Page...
Save Workspace...
Send To
Web Page Preview

New! Excel User Group Now Open @ www.excelusergroup.org, Check It Out!


Menu command Type What happens next?
Web Page Preview   Simply shows a preview of the current worksheet in a web browser. In effect similar to print preview but without the ability to change settings.

VBA Sub xlWebPagePreview()
Dim wb As Workbook
Set wb = ActiveWorkbook
'Do whatever you need to with workbook here using wb variable
wb.WebPagePreview
End Sub

Copyright Nick Hodge 2008. All Rights Reserved.