Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba code to block review toolbar
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thank you - where do I put it vba code to block review toolbar
Thanks for the time - where do I place this code to make
it universally available to all workbooks opened on my machine. -----Original Message----- 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...biTMYDHA.3444% 40tk2msftngp13.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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thank you - where do I put it vba code to block review toolbar
Todd,
Put it in a macro named Auto_Open in your personal.xls workbook. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Todd F" wrote in message ... Thanks for the time - where do I place this code to make it universally available to all workbooks opened on my machine. -----Original Message----- 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...biTMYDHA.3444% 40tk2msftngp13.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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thank you - where do I put it vba code to block review toolbar
Hi Todd
Open a new workbook Alt-F11 InsertModule from the menubar paste the sub in there Alt-Q to go back to Excel If you do Alt-F8 you get a list of your macro's Select "test" and press Run Sub test() Application.CommandBars("Reviewing").Enabled = False End Sub Close the workbook (don't save it) -- Regards Ron de Bruin http://www.rondebruin.nl "Todd F" wrote in message ... Thanks for the time - where do I place this code to make it universally available to all workbooks opened on my machine. -----Original Message----- 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...biTMYDHA.3444% 40tk2msftngp13.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 . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
thanks
-----Original Message----- Hi Todd Open a new workbook Alt-F11 InsertModule from the menubar paste the sub in there Alt-Q to go back to Excel If you do Alt-F8 you get a list of your macro's Select "test" and press Run Sub test() Application.CommandBars("Reviewing").Enabled = False End Sub Close the workbook (don't save it) -- Regards Ron de Bruin http://www.rondebruin.nl "Todd F" wrote in message ... Thanks for the time - where do I place this code to make it universally available to all workbooks opened on my machine. -----Original Message----- 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? threadm=eJQbiTMYDHA.3444% 40tk2msftngp13.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 . . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
thanks
-----Original Message----- Todd, Put it in a macro named Auto_Open in your personal.xls workbook. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Todd F" wrote in message ... Thanks for the time - where do I place this code to make it universally available to all workbooks opened on my machine. -----Original Message----- 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? threadm=eJQbiTMYDHA.3444% 40tk2msftngp13.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 . . |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba code to block review toolbar
Todd F wrote: *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 * Cudos to Ron de Bruin and Jim Resch. I have suffered for years with Reviewing Toolbar, in my own Word docs, and when it showed up in an Excel file too, I went looking for, and found their answers. But for solving my own creating of Word docs with Reviewing Toolbar I used Word to open the Normal.dot template (File - Open - C:\Documents and Settings\my username\Application Data\Microsoft\Templates\Normal.dot) Once opened, I turned off the Reviewing Toolbar (View - Toolbars - Reviewing toolbar) and then saved my changes. Now when I create a new document, I'm no longer one of those that generates documents that require the Reviewing toolbar. -- jacksprat ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message818309.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I stop the Web and Review toolbar opening up randomly? | Excel Discussion (Misc queries) | |||
review toolbar reappears | Excel Discussion (Misc queries) | |||
code that might be causing error - please review and comment | Excel Programming | |||
VB6 with Excel Objects: Please review my code | Excel Programming | |||
Two Questions about the Following Block of Code | Excel Programming |