Toolbar Option > Reviewing (XP; SP3)

[jstevens]

I have an annoying problem when someone sends me an Excel file or when I retrieve one from a shared LAN drive. Tthe file I am trying to open has the View>Toolbars>Reviewing option selected. Either way the individual saving the file saved it with this particular setting. I have tried modifying my "Personal.xls" file that upon opening a file would reset it to false:

Private Sub Workbook_Open()
Application.CommandBars("Reviewing").Visible = False
End Sub

This apparently does not work. Any suggestions?

Thanks,
John

[TonyE]

Hi John

Use the following line instead

Application.CommandBars("Reviewing").Enabled = False

[jstevens]

Tony,

Your suggestion did not work.

John

[TonyE]

Hi John

That is the usual method but it does not work all the time and the reviewing toolbar can come back. See the thread beginning with <post#=316593>post 316593</post#> for further on this issue.

[unkamunka]

Try <code>Application.CommandBars("Reviewing").Reset </code> HTH