vba code to block review toolbar
 

In my little world I get many excel files sent to me.

I would be very greatful if someone was to enlighten me
with the the code need to block the review toolbar form
pooping up whe I open an incoming spread sheet.

Also where do you place the code - personal?


It messes with my tool bar buttons and add's and add's
another row - it is driving me insane.

If I cant block it I want to know how to taer it out of
my excel. Line by line if need be.

Thanks you for your time.

Todd

vba code to block review toolbar
 

Hi Todd

You can use this line to disable it if you don't want to see it again
Application.CommandBars("Reviewing").Enabled = False
Set it to true to use it again


Or check out this posting from Jim Rech

From: Jim Rech )
Subject: Reviewing Toolbar
Newsgroups: microsoft.public.excel.misc
Date: 2003-01-09 04:22:21 PST


Actually I believe the annoying popup Reviewing toolbar is triggered by
certain custom file properties. Go into File, Properties and the Custom
tab. There you will probably find several custom properties that begin with
underscores (as I recall). If you delete them and save the workbook and
close the Reviewing toolbar, I think the next time you open the workbook the
toolbar will not appear.


And if you want a macro to clean this up, Jim posted this:
http://groups.google.com/groups?thre...gp13.phx .gbl


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Todd F" wrote in message ...
In my little world I get many excel files sent to me.

I would be very greatful if someone was to enlighten me
with the the code need to block the review toolbar form
pooping up whe I open an incoming spread sheet.

Also where do you place the code - personal?


It messes with my tool bar buttons and add's and add's
another row - it is driving me insane.

If I cant block it I want to know how to taer it out of
my excel. Line by line if need be.

Thanks you for your time.

Todd

Thank you - where do I put it vba code to block review toolbar
 

Thanks for the time - where do I place this code to make
it universally available to all workbooks opened on my
machine.
-----Original Message-----
Hi Todd

You can use this line to disable it if you don't want to
see it again
Application.CommandBars("Reviewing").Enabled = False
Set it to true to use it again


Or check out this posting from Jim Rech

From: Jim Rech )
Subject: Reviewing Toolbar
Newsgroups: microsoft.public.excel.misc
Date: 2003-01-09 04:22:21 PST


Actually I believe the annoying popup Reviewing toolbar
is triggered by
certain custom file properties. Go into File,
Properties and the Custom
tab. There you will probably find several custom
properties that begin with
underscores (as I recall). If you delete them and save
the workbook and
close the Reviewing toolbar, I think the next time you
open the workbook the
toolbar will not appear.


And if you want a macro to clean this up, Jim posted
this:
http://groups.google.com/groups?thre...biTMYDHA.3444%
40tk2msftngp13.phx.gbl


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Todd F" wrote in
message ...
In my little world I get many excel files sent to me.

I would be very greatful if someone was to enlighten me
with the the code need to block the review toolbar form
pooping up whe I open an incoming spread sheet.

Also where do you place the code - personal?


It messes with my tool bar buttons and add's and add's
another row - it is driving me insane.

If I cant block it I want to know how to taer it out of
my excel. Line by line if need be.

Thanks you for your time.

Todd


.

Thank you - where do I put it vba code to block review toolbar
 

Todd,

Put it in a macro named Auto_Open in your personal.xls workbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Todd F" wrote in message
...
Thanks for the time - where do I place this code to make
it universally available to all workbooks opened on my
machine.
-----Original Message-----
Hi Todd

You can use this line to disable it if you don't want to
see it again
Application.CommandBars("Reviewing").Enabled = False
Set it to true to use it again


Or check out this posting from Jim Rech

From: Jim Rech )
Subject: Reviewing Toolbar
Newsgroups: microsoft.public.excel.misc
Date: 2003-01-09 04:22:21 PST


Actually I believe the annoying popup Reviewing toolbar
is triggered by
certain custom file properties. Go into File,
Properties and the Custom
tab. There you will probably find several custom
properties that begin with
underscores (as I recall). If you delete them and save
the workbook and
close the Reviewing toolbar, I think the next time you
open the workbook the
toolbar will not appear.


And if you want a macro to clean this up, Jim posted
this:
http://groups.google.com/groups?thre...biTMYDHA.3444%
40tk2msftngp13.phx.gbl


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Todd F" wrote in
message ...
In my little world I get many excel files sent to me.

I would be very greatful if someone was to enlighten me
with the the code need to block the review toolbar form
pooping up whe I open an incoming spread sheet.

Also where do you place the code - personal?


It messes with my tool bar buttons and add's and add's
another row - it is driving me insane.

If I cant block it I want to know how to taer it out of
my excel. Line by line if need be.

Thanks you for your time.

Todd


.

Thank you - where do I put it vba code to block review toolbar
 

Hi Todd

Open a new workbook

Alt-F11
InsertModule from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run

Sub test()
Application.CommandBars("Reviewing").Enabled = False
End Sub

Close the workbook (don't save it)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Todd F" wrote in message ...
Thanks for the time - where do I place this code to make
it universally available to all workbooks opened on my
machine.
-----Original Message-----
Hi Todd

You can use this line to disable it if you don't want to
see it again
Application.CommandBars("Reviewing").Enabled = False
Set it to true to use it again


Or check out this posting from Jim Rech

From: Jim Rech )
Subject: Reviewing Toolbar
Newsgroups: microsoft.public.excel.misc
Date: 2003-01-09 04:22:21 PST


Actually I believe the annoying popup Reviewing toolbar
is triggered by
certain custom file properties. Go into File,
Properties and the Custom
tab. There you will probably find several custom
properties that begin with
underscores (as I recall). If you delete them and save
the workbook and
close the Reviewing toolbar, I think the next time you
open the workbook the
toolbar will not appear.


And if you want a macro to clean this up, Jim posted
this:
http://groups.google.com/groups?thre...biTMYDHA.3444%
40tk2msftngp13.phx.gbl


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Todd F" wrote in
message ...
In my little world I get many excel files sent to me.

I would be very greatful if someone was to enlighten me
with the the code need to block the review toolbar form
pooping up whe I open an incoming spread sheet.

Also where do you place the code - personal?


It messes with my tool bar buttons and add's and add's
another row - it is driving me insane.

If I cant block it I want to know how to taer it out of
my excel. Line by line if need be.

Thanks you for your time.

Todd


.

thanks
 

-----Original Message-----
Hi Todd

Open a new workbook

Alt-F11
InsertModule from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run

Sub test()
Application.CommandBars("Reviewing").Enabled = False
End Sub

Close the workbook (don't save it)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Todd F" wrote in
message ...
Thanks for the time - where do I place this code to
make
it universally available to all workbooks opened on my
machine.
-----Original Message-----
Hi Todd

You can use this line to disable it if you don't want
to
see it again
Application.CommandBars("Reviewing").Enabled = False
Set it to true to use it again


Or check out this posting from Jim Rech

From: Jim Rech )
Subject: Reviewing Toolbar
Newsgroups: microsoft.public.excel.misc
Date: 2003-01-09 04:22:21 PST


Actually I believe the annoying popup Reviewing
toolbar
is triggered by
certain custom file properties. Go into File,
Properties and the Custom
tab. There you will probably find several custom
properties that begin with
underscores (as I recall). If you delete them and
save
the workbook and
close the Reviewing toolbar, I think the next time you
open the workbook the
toolbar will not appear.


And if you want a macro to clean this up, Jim posted
this:
http://groups.google.com/groups?
threadm=eJQbiTMYDHA.3444%
40tk2msftngp13.phx.gbl


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Todd F" wrote
in
message ...
In my little world I get many excel files sent to
me.

I would be very greatful if someone was to
enlighten me
with the the code need to block the review toolbar
form
pooping up whe I open an incoming spread sheet.

Also where do you place the code - personal?


It messes with my tool bar buttons and add's and
add's
another row - it is driving me insane.

If I cant block it I want to know how to taer it
out of
my excel. Line by line if need be.

Thanks you for your time.

Todd


.



.

thanks
 

-----Original Message-----
Todd,

Put it in a macro named Auto_Open in your personal.xls
workbook.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Todd F" wrote in
message
...
Thanks for the time - where do I place this code to
make
it universally available to all workbooks opened on my
machine.
-----Original Message-----
Hi Todd

You can use this line to disable it if you don't want
to
see it again
Application.CommandBars("Reviewing").Enabled = False
Set it to true to use it again


Or check out this posting from Jim Rech

From: Jim Rech )
Subject: Reviewing Toolbar
Newsgroups: microsoft.public.excel.misc
Date: 2003-01-09 04:22:21 PST


Actually I believe the annoying popup Reviewing
toolbar
is triggered by
certain custom file properties. Go into File,
Properties and the Custom
tab. There you will probably find several custom
properties that begin with
underscores (as I recall). If you delete them and
save
the workbook and
close the Reviewing toolbar, I think the next time you
open the workbook the
toolbar will not appear.


And if you want a macro to clean this up, Jim posted
this:
http://groups.google.com/groups?
threadm=eJQbiTMYDHA.3444%
40tk2msftngp13.phx.gbl


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Todd F" wrote
in
message ...
In my little world I get many excel files sent to
me.

I would be very greatful if someone was to
enlighten me
with the the code need to block the review toolbar
form
pooping up whe I open an incoming spread sheet.

Also where do you place the code - personal?


It messes with my tool bar buttons and add's and
add's
another row - it is driving me insane.

If I cant block it I want to know how to taer it
out of
my excel. Line by line if need be.

Thanks you for your time.

Todd


.



.

vba code to block review toolbar
 

Todd F wrote:
*In my little world I get many excel files sent to me.

I would be very greatful if someone was to enlighten me
with the the code need to block the review toolbar form
pooping up whe I open an incoming spread sheet.

Also where do you place the code - personal?


It messes with my tool bar buttons and add's and add's
another row - it is driving me insane.

If I cant block it I want to know how to taer it out of
my excel. Line by line if need be.

Thanks you for your time.

Todd *

Cudos to Ron de Bruin and Jim Resch. I have suffered for years with
Reviewing Toolbar, in my own Word docs, and when it showed up in an
Excel file too, I went looking for, and found their answers.
But for solving my own creating of Word docs with Reviewing Toolbar I
used Word to open the Normal.dot template (File - Open - C:\Documents
and Settings\my username\Application
Data\Microsoft\Templates\Normal.dot)
Once opened, I turned off the Reviewing Toolbar (View - Toolbars -
Reviewing toolbar) and then saved my changes.
Now when I create a new document, I'm no longer one of those that
generates documents that require the Reviewing toolbar.



--
jacksprat
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message818309.html