View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default How to prevent Reviewing Toolbar from appearing constantly?

Alt + F11, in the project pane to the left find the personal.xls and double
click ThisWorkbook


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Barb Reinhardt" wrote in message
...
Bob, where do you find the Workbook_Open event in the personal.xls file?

"Bob Umlas, Excel MVP" wrote:

in your personal.xls file's Workbook_Open event, hide the toolbar:
Private Sub Workbook_Open()
Application.CommandBars("Reviewing").Visible = False
End Sub

"korrye" wrote:

Reviewing toolbar reappears everytime Excle is opened. How do I
prevent that
from happening?