How to prevent Reviewing Toolbar from appearing constantly?

[korrye]

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

 

[Barb Reinhardt]

Right click in the toolbar and DESELECT the Reviewing toolbar.

 

[Bob Umlas, Excel MVP]

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

 

[Barb Reinhardt]

Bob, where do you find the Workbook_Open event in the personal.xls file?

 

[Peo Sjoblom]

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]

That wasn't the question. Is the workbook_open event present in the
personal.xls workbook by default, or must I add it to the personal.xls
workbook to do what was suggested previously?

 

[Peo Sjoblom]

I assumed that you knew that you could paste the code Bob gave you into the
window that opens when you double click ThisWorkbook. To answer your
question, the workbook open event is somewhat present but just the first and
the last line, in that window that opens if you would have followed my
instructions there is a dropdown, default is General but you can select
Workbook from there and when you do you'll get this

Private Sub Workbook_Open()

End Sub

your code would go in there, bust since Bob gave you all the code you could
just paste it into the blank window without selecting from the dropdown
first

then on the right hand side you can see the different events that are
available, obviously you must put in the code that you want the event to
execute

Of course Personal.xls has to be created first, it's not there by default


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Barb Reinhardt]

Thank you. That answers my question.

I assumed that you knew that you could paste the code Bob gave you into the
window that opens when you double click ThisWorkbook. To answer your
question, the workbook open event is somewhat present but just the first and
the last line, in that window that opens if you would have followed my
instructions there is a dropdown, default is General but you can select
Workbook from there and when you do you'll get this

Private Sub Workbook_Open()

End Sub

your code would go in there, bust since Bob gave you all the code you could
just paste it into the blank window without selecting from the dropdown
first

then on the right hand side you can see the different events that are
available, obviously you must put in the code that you want the event to
execute

Of course Personal.xls has to be created first, it's not there by default


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com