Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Toolbar Option > Reviewing (XP; SP3)

    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

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Toolbar Option > Reviewing (XP; SP3)

    Hi John

    Use the following line instead

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

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toolbar Option > Reviewing (XP; SP3)

    Tony,

    Your suggestion did not work.

    John

  4. #4
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Toolbar Option > Reviewing (XP; SP3)

    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.

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Toolbar Option > Reviewing (XP; SP3)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •