View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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