How to prevent Reviewing Toolbar from appearing constantly?

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in
>> message
>> news:[email protected]...
>> > 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in
> >> message
> >> news:[email protected]...
> >> > 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?
> >>
> >>
> >>
>
>
>