ExcelBanter

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

Jonathan Cooper

Reviewing Toolbar (permanent fix)
 
A few days back, somene else was asking about the reviewing toolbar and I
didn't have this link readily available.

This will make it go away for good. Can't take credit for it myself though.

http://groups-beta.google.com/group/...xy=2004&rnum=1


Dave Peterson Jan 20, 4:39 pm show options

Newsgroups: microsoft.public.excel.misc
From: Dave Peterson
Date: Tue, 20 Jan 2004 18:37:03 -0600
Local: Tues, Jan 20 2004 4:37 pm
Subject: Disable Toolbars... Permanently


You want to kill it forever?


This seemed to work ok for me:


Open excel
hit alt-F11 to get to the VBE
hit ctrl-G to see the immediate window


Type this in and hit enter:
application.CommandBars("reviewing").Enabled = False


If you ever want it back, you can toggle it to true.


Dave Peterson







All times are GMT +1. The time now is 04:47 PM.

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