disable Review toolbar which came up automatically when opening a.

How can I disable the Review Toolbar which comes up automatically when 
opening a file?
0
10/2/2004 5:09:07 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
498 Views

Similar Articles

[PageSpeed] 52

In the Workbook VBA actions.

The top left hand corner there is an Excel logo, not the one in th
blue program bar, but in the menu bar.

Right Click and select "View Code"

There will be two drop down boxes one that will probably say General
if this has never been entered previously.

Change the box on the right to Workbook.

Then Change the right hand box to "Activate"

Insert the following code

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

exit the VBA screen and then every time the file opens it will ensur
that the Reviewing Toolbar is not shown.

I hope this helps

Celtic_Avenger
:)  :)  :)  :)  :

--
Celtic_Avenge
-----------------------------------------------------------------------
Celtic_Avenger's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1410
View this thread: http://www.excelforum.com/showthread.php?threadid=26575

0
10/2/2004 5:20:48 PM
The Reviewing toolbar in Excel pops up whenever you open a workbook that has
been emailed from within Excel "for review".  There may be other ways to
make this happen too.  If you do a File, Properties you'll see the custom
file properties that have been added that triggers this.

You can kill the added file properties manually or run the below macro to do
it if you're familiar with macros.  I keep this macro is in my Personal and
attached to a toolbar button.

-- 
Jim Rech
Excel MVP

Sub KillReviewingCustProps()
    Dim x As DocumentProperties
    Dim Counter As Integer
    Set x = ActiveWorkbook.CustomDocumentProperties
    For Counter = x.Count To 1 Step -1
        If Left(x.Item(Counter).Name, 1) = "_" Then _
          x.Item(Counter).Delete
    Next
    CommandBars("Reviewing").Visible = False
End Sub

-- 
Jim Rech
Excel MVP
"ching.chiu" <ching.chiu@discussions.microsoft.com> wrote in message 
news:E22395BF-7B51-4FF2-8B98-E1DE8F539788@microsoft.com...
> How can I disable the Review Toolbar which comes up automatically when
> opening a file? 


0
jrrech (1932)
10/2/2004 8:34:27 PM
Reply:

Similar Artilces:

Opening Word
When I open Word 2007 - it opens with a (template?) to make a header - on the page. I want it to open with a completely blank page with my default margins and type style. Thank you See http://word.mvps.org/FAQs/AppErrors/BlankDocNotBlank.htm. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. On Sat, 20 Feb 2010 11:46:01 -0800, heread <heread@discussions.microsoft.com> wrote: >When I open Word 2007 - it opens with a (template?) to make a hea...

Automatically finishes entering email into TO box
How do I tell MS Outlook to automatically finish entering into the TO box (sending email)when I begin typing the person to whom I am sending mail? thanks! What version of Outlook? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the SWEN virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Gem asked: | How do I tell MS Outlook to automatically finish entering | into the TO box (sending email)when I begin typing the | person to whom I am sending mail? | t...

How to parse message automatically
I want to use a rule to parse the information in emails from a specific email address, convert the content into a MS Word template format, and then email the document as an attachment to an email address that will be one of the "fields" in the received email. Anyone who has had experience with anything like this? Thanks You may need to use VBA, but take a look at www.ornic.com - exlife might do what you need. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Outlook Tips: http://www...

Automatically fill down formulas when adding a record
I have a data entry sheet which receives one record per row. Some of th columns contain calculated fields and will be hidden. Is there a way t have the formulas automatically fill down when new records are added Thank you -- Message posted from http://www.ExcelForum.com One way is to use Excels built-in dataform. data>form -- John johnf 202 at hotmail dot com "steveski >" <<steveski.11dx8c@excelforum-nospam.com> wrote in message news:steveski.11dx8c@excelforum-nospam.com... | I have a data entry sheet which receives one record per row. Some of the | columns con...

How do I get MSWord for Mac to keep its toolbars?
Each time I open MSWord for Mac 2008 I have to re-configure to view the standard and formatting toolbars. Then when I start a "new blank document", those toolbars have gone and I have to go to "View>Toolbars>Formatting" and see it is already ticked. So I have to un-tick it and then re-tick it before it re-appears. And then I have to do the same for the standard toolbar. Anyone have any ideas? ...

Outlook Not responding when I open it despite reboots
My outlook 2002 on my laptop with XP will not start. The window opens and it tries to get my mail but locks up and says this program is not responding. On the error message that it wants you to send to microsoft the following is listed: szAppName: szAppVer: 0.0.0.0. szModName: hungapp szModVer: 0.0.0.0. offset: 0000000 I have shut down the network, rebooted multiple times, virus scanned, etc. and it still won't work. Was working fine when I went to bed last night. HELPPPPP!!! Pleaseee!!!! Can't do my business without my email. THanks Holly ...

I haven't opened it
Somehow all messages hitting my Inbox are showing as opened. I am running on Exchange 2003 and also use Good Software to push email to my phone. Also shows as opend on my phone. As far as I know I am the only person in the organization that this is happening to. Any thoughts as to what could be causing this? On Sun, 23 Oct 2005 06:29:08 -0700, "NOBI" <NOBI@discussions.microsoft.com> wrote: >Somehow all messages hitting my Inbox are showing as opened. I am running on >Exchange 2003 and also use Good Software to push email to my phone. Also >shows as opend on my p...

Toggling "Shutter Bar Open-Close Button"
I have looked but can't find a way to control Toggling "Shutter Bar Open/Close Button" within a module. Any ideas? Additionally, I would be interested in expanding and contracting what is visible in the Shutter Bar (Navigation Bar). ...

Disable "remove" attachment from Notes?
By removing the "delete" privilege from the Notes entity from a security role, an User assigned with the role can be prevented from deleting a Note. But it does not prevent the User from removing the file attachment attached to the Notes. Question. Is there any workaround or intelligent customization to prevent the removing of file attachments? Hi Daniel, try limiting the NOTES - WRITE privileges to "none" Vivi - MS CRM consultant "Daniel" wrote: > By removing the "delete" privilege from the Notes entity from a security > role, an U...

macro disabled permanently
Greetings, I interrupted a macro I wrote that went into infinite loop by hitting ESC. I fixed the macro function which is tied to "Worksheet_Change". Now it never gets triggered. I put break points in code; not executed at all. I close/open excel and respond to security dialog as "enable macros", still not working. I don't know what happened but code never gets executed. I don't know what happened. Help appreciated, Cagdas Ozgenc Sounds like events have been disabled. Type Application.EnableEvents = True in the VBIDE immediate window. -- HTH Bob Phillip...

Files will not open.
I loaded Pub 2003 but cannot open previous Pub 98 files. Noton Virus is not the problem as the prevoius Pub 98 files as Norton was not installed. Greetings, I wanted to provide a bit more information on my problem. I have 2 computers, one with Publisher 98 and one with Publisher 2003. I have a bunch of files made in Publisher 98 that won't open in Publisher 2003. When I try and click on a publisher file or open the file from within Publisher 2003, I get the error "Publisher cannot open the file". The files are not corrupted during the copy process, because if I copy them ba...

Custom Toolbar Button Question
Hello , I have a GP 9 and I would like to create a custom toolbar button that executes some Dex code. I need to be able to access the data on the current form because I want to invoke an a third party api using some of the field values as variables to pass into the third party api as parameters. I have the dex code for the third party api working fine but I was wondering if someone could point me to a sample. What content objects are available? Thanks, gsvi HI, I have done this before and once you master the concept it's not too hard. It is very close to implementing menu command...

Open Office and Microsoft Works
How can I get my browser to choose the spread sheet from Open Office instead of Microsoft Works' when trying to open an XLS file? As it stands the latter automatically opens it. Windows Vista Home Premium SP2, 32 bit and IE 8. The reason: the file doesn't open properly as is, IOW a calendar shows up in sections of four and incomplete as such. TIA, Harry. "webster72n" <webster72n@gmail.com> wrote in message news:OU2jlY#lKHA.4148@TK2MSFTNGP05.phx.gbl... > How can I get my browser to choose the spread sheet from Open Office > instead of Mic...

Outlook 2000 slow at opening new emails
Hello... We have a WinXP Pro laptop on a NT network with Outlook 2000 on it, the laptop has a standard network conection and syncs emails when off-line. It also has a bluetooth connection, but the default connection is a standard network port. When a new email comes in and the user tries to open the email Outlook hangs. We did do a system restore which seemed to help but the problem comes back again. No new software had been added so I'm not sure why a system restore worked, initially. Could it be something to do with the network connection and email sync...or what? It's the company ...

Enable/Disable Macro Pop-Up
In the older version of Office when you opened an excel or other office document that had a macro in it - you would get a pop up and the opportunity to enable or disable it. Is there a way to get that same pop-up in 2007? See Help, macro setting Change macro security settings in Excel juamig wrote: > In the older version of Office when you opened an excel or other office > document that had a macro in it - you would get a pop up and the opportunity > to enable or disable it. Is there a way to get that same pop-up in 2007? > Right, someone else told me the...

External Links on open and Excel 2003
I am opening a spreadsheet in Excel 2003 that contains links to external sources. This spreadsheet was created in Excel 97. When I open it, I am prompted to update or not update. I choose don't update, as I don't have the linked files. BUT, it seems that Excel tries to update anyway because it is the same result as if I hit update, and all of my values are gone. This seems to be a change from excel 97 as excel 97 left the values. Any ideas? I likely have a default setting incorrect somewhere. Thanks! --- Message posted from http://www.ExcelForum.com/ khoff Wrote...

Enable automatic refresh
I do have an exel sheet with a automatic query. I changed to a new computer and when I open the file now, it always asking "Enable automatic refresh" or "disable automatic refresh". I already removed the "v" by the Options on the Edit-page by "Ask to update automatic links" and by Calculation, it did put a "V" by "Update remote references". Still it always ask to confirm to "Enable" or "Disble" when I open the file again. How can help me out? Thanks, Marc ...

Open Publisher 2003 in Publisher 2000
I've created a document in Publisher 2003 at home. I've sent it to my Office where we have Publisher 2000 and find I can't open it. Is there anything I can do to open it? Save as... a 2000 document at home. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Nalp30" <Nalp30@discussions.microsoft.com> wrote in message news:4002B348-7FF3-4CB0-A53E-1115001605CE@microsoft.com... > I've created a document in Publisher 2003 at home. I've sent it to my Office > where we have Publisher 2000 and fin...

Opening file from an item loses Word document properties
Hello, I have just discovered that when you double-click a Word file attached to an appointment item (although I imagine it will be the same for other items too), Outlook does not open the actual file, but takes a copy and puts it in the temp folder and opens that. This is a pain as it mucks up some of the automation coding I have done, but what's worse is that the copy doesn't seem to have the custom properties I have set. Is there any way of forcing Outlook to open the original, instead of a copy? Failing that, any ideas why the custom document property would have been lost...

Putting symbols automatically
I have a spreadsheet I created with a thousands of number codes. Now I need to put "* to the beginning and *" to end of the code. How can I do this? i.e. 123-23 to "*123-23*" Please help. Thank you. Maybe a helper column: ="*" & a1 & "*" And drag down. Ted S wrote: > > I have a spreadsheet I created with a thousands of number codes. Now I need > to put "* to the beginning and *" to end of the code. How can I do this? > > i.e. > 123-23 to "*123-23*" > > Please help. > > Thank yo...

CRM toolbar is not visible in an Outlook custom contact form
Greetings, We have a client using a Custom Outlook Contact Form and when they open the form, the CRM toolbar is not visible nor does it appear that it can be added via View.Toolbars. Does anyone know a way to add the CRM toolbar to a custom Outlook Contact form so that we can use the Track in CRM and Set Parent functionality on a contact. This is for Office 2003 SP2. Jack Bender ...

help needed! can't open my pst file
hi.. need your expetise... :) im really desperate to open my pst files. im having a hard time to open it. i encountered errors when opening the file. like: this file is not a personal folders file. i already tried to run scanpst.exe, but no good. tried to import/export files but really cant get through. even tried the data file management option.. but still no luck! :( need help... please.. i can send you the file to try it on.. :) please advise.. thanks in advance, bambz Sorry, but the most basic information is missing - version of Outlook and where the .pst file is stored. --� Milly ...

Automatic deleting of Text ?
I receive regular and a substantial number of (acceptable) messages which contain, at the foot of the message, a "PRIVACY & CONFIDENTIALTY NOTICE". This message is added to the original message automatically, but is clearly not required, nor it it required on replies, which then generate another version of the notice. Is it possible to create a VB script that could do this, perhaps from a toolbar command. Although the actual place of the message will naturally vary (from the start of the message) depending on its length, but it will always be the (around 20) last lines of the me...

Can Excel open a new application for every file opened?
We have someone who wants a new application of Excel to open every time they open a file. Where is the setting for this? I'm going to hope that they actually just want to see an Excel icon on the task bar for each workbook that is open. (Creating a new instance of the Excel application for each file opened is generally a bad idea for many reasons) So, try this: Tools>Options>View Select: Windows in Taskbar Does that help? *********** Regards, Ron "shoon" wrote: > We have someone who wants a new application of Excel to open every time they > open a file. ...

Impossible to open Money
Hello, I just installed Money 2005 (came in a bundle Works Suite 2006) on my WinXP. I entered my user name and password of my Microsoft Passport. But it says it's ot the good ones and closes he program ! So I never saw a sheet of this program ! 1) On which criteria is it thinking it's not the good username and password ??? Does it check the name of my Computer or the name in my Outlook Express, or the name in my bank account, and want it to be the same as in my Passport account ??? 2) Is it possible to use it without internet connexion ? 3) Is there any other software I could use, t...