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


.