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

Right click in the toolbar and DESELECT the Reviewing toolbar.

"korrye" wrote:

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

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?

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?

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?

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" wrote:

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?

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" wrote in message
...
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" wrote:

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?

Thank you. That answers my question.

"Peo Sjoblom" wrote:

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" wrote in message
...
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" wrote:

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?