Results 1 to 1 of 1
Thread: CommandBar Suggestion (XP)
2004-05-25, 20:27 #1
- Join Date
- Dec 2000
- California, USA
- Thanked 0 Times in 0 Posts
CommandBar Suggestion (XP)
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
.Controls("Toolbars").Enabled = False
Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)tab] 'Turns Web feature on and enables Toolbar
Application.CommandBars("Web").Visible = True
.Controls("Toolbars").Enabled = True
Any suggestions would be appreciated.