Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Web link to Excell

Status
Not open for further replies.

NTOldTimer

Programmer
Jun 26, 2003
243
US
We use Front Page to modify our web page. When a hyperlink points to an excell workbook it doesn't open in the Excell applicaion full screen to the Excell window. Is there a way to get it to open full screen (inside the Excell application)?
 
Put the following line of code into the excel workbook:

Private Sub Workbook_Open()
Application.DisplayFullScreen = True
End Sub
 
There is also a user setting on individual machines that causes some Microsoft-product-created files to open in the same web browser you click the link in. Would the above circumvent this, or would the user's Folder Options/File Types still have to have "Browse in same window" turned off for Excel?

Cheryl dc Kern
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top