I utilize a third party web utility to open XL file(s) posted to a server. Since migrating to XP an issue has surfaced where the path to the file can be viewed via an address bar if the End User has the following option set: View>Toolbars>Web.

What I came up with was to place this line of code in the workbook object. The problem being that once things are turned back on, the path is still diplayed although the XL workbook is closed.

Private Sub Workbook_WindowActivate(ByVal Wn As Window) 'Turns Web feature off and disables Toolbar
Application.CommandBars("Web").Visible = False
With Application.CommandBars("View")
.Controls("Toolbars").Enabled = False
End With
End Sub

Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)tab] 'Turns Web feature on and enables Toolbar
Application.CommandBars("Web").Visible = True
With Application.CommandBars("View")
.Controls("Toolbars").Enabled = True
End With
End Sub


Any suggestions would be appreciated.
John