Re: How to prevent Reviewing Toolbar from appearing constantly?
- From: "Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com>
- Date: Tue, 9 May 2006 11:08:58 -0700
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" <BarbReinhardt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5FED2D0B-C235-42C8-AD31-8DB895FE709C@xxxxxxxxxxxxxxxx
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" <BarbReinhardt@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:738C6711-ADBD-422F-9566-9A1EBBDE44E9@xxxxxxxxxxxxxxxx
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?
.
- Follow-Ups:
- Re: How to prevent Reviewing Toolbar from appearing constantly?
- From: Barb Reinhardt
- Re: How to prevent Reviewing Toolbar from appearing constantly?
- References:
- Re: How to prevent Reviewing Toolbar from appearing constantly?
- From: Peo Sjoblom
- Re: How to prevent Reviewing Toolbar from appearing constantly?
- Prev by Date: Re: Cell to be mandatory fill in
- Next by Date: Re: Entering a range of numbers and searching same
- Previous by thread: Re: How to prevent Reviewing Toolbar from appearing constantly?
- Next by thread: Re: How to prevent Reviewing Toolbar from appearing constantly?
- Index(es):
Relevant Pages
|
