#1   Report Post  
DJ
 
Posts: n/a
Default Reviewing Toolbar

I keep getting the Reviewing toolbar when I open workbooks. But I don't want
to see it ... ever. I cannot delete the Reviewing toolbar directly from the
Toolbars dialog. I could write a VBA macro that will kill it if I click a
button, but that doesn't really save me much, as I can get rid of it from the
Toolbars menu.

What I want is never, ever, ever, under any circumstances, to see it again.
I do not want to have to click buttons to get rid of it when it comes up, I
want never to have it come up at all. Given how customizable Excel is
generally, I can't conceive of why there would be no way for me to prevent
this toolbar, which I never, ever use, from coming up.
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi DJ

Run this code line one time

Application.CommandBars("Reviewing").Enabled = False

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



"DJ" wrote in message ...
I keep getting the Reviewing toolbar when I open workbooks. But I don't want
to see it ... ever. I cannot delete the Reviewing toolbar directly from the
Toolbars dialog. I could write a VBA macro that will kill it if I click a
button, but that doesn't really save me much, as I can get rid of it from the
Toolbars menu.

What I want is never, ever, ever, under any circumstances, to see it again.
I do not want to have to click buttons to get rid of it when it comes up, I
want never to have it come up at all. Given how customizable Excel is
generally, I can't conceive of why there would be no way for me to prevent
this toolbar, which I never, ever use, from coming up.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to prevent "Reviewing" toolbar from "automatically" appearing? FishHead Excel Discussion (Misc queries) 1 March 30th 05 05:00 PM
reviewing toolbar always there... JEV Excel Discussion (Misc queries) 1 February 23rd 05 10:14 PM
Annoying Reviewing Toolbar Excel XP Jared Excel Discussion (Misc queries) 1 January 29th 05 12:42 AM
Reviewing Toolbar - how to stop it from displaying Jay Excel Worksheet Functions 1 December 1st 04 12:51 AM
How do I stop the Reviewing toolbar from showing up in Excel? RickKel Excel Discussion (Misc queries) 2 November 26th 04 05:37 PM


All times are GMT +1. The time now is 08:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"