Reviewing Toolbar (2002 SP3)

Topic

New Reply

I am sure it is something simple that I am not getting. I have tried several methods found in the forums on how to keep the reviewing tool bar from being visible when opening an Excel workbook. I have not figured it out yet. Any help would be very appreciated on what I am doing wrong with the attached file. I also left in the different ways that I tried. So there will be some redundant lines of code in the modules.

Thank You,

Reply | Quote

Replies

Ah, no that persistent thing is a pain!

I put this one line code and attached to a toolbar button to get rig of it. Or you could assign a keyboard shortcut.


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


Reply | Quote

The Workbook_Open procedure should be in the ThisWorkbook module if you want it to be executed automatically. It won’t be executed automatically if you put it in a standard module or in a class module.

Reply | Quote

Thanks for the replies, it works just fine now.

Reply | Quote