ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Reviewing Toolbar (https://www.excelbanter.com/excel-discussion-misc-queries/27979-reviewing-toolbar.html)

DJ

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.

Ron de Bruin

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.





All times are GMT +1. The time now is 08:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com