| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Web Toolbar when Open A Hyperlink workbook
Thank you, Gord Dibben.
"Gord Dibben" wrote: A recent posting from Jim Rech addresses this. Jim post.................. 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. Gord adds this part........................ One other way that makes it happen is when you open via hyperlink. Resume Jim post............................... 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. This macro is in my Personal and attached to a toolbar button because I feel the same way as you about this toolbar. 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 End Jim post....................... Gord Dibben Excel MVP On Thu, 31 Jul 2008 18:32:01 -0700, T_Yuri wrote: Hi Gray, Good Day and Thank your reply. Actually I understood that I can uncheck the <Web toolbar when I open a shared workbook. But it's trouble for me to uncheck it every time. I don't like them and I hope it can be hide or delete permanently unless I ask / call for them. Do you have any suggestion ? "Gary''s Student" wrote: View Toolbars uncheck Web -- Gary''s Student - gsnu200796 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom toolbar item to use hyperlink to open word file | Excel Discussion (Misc queries) | |||
| Web toolbar appears after hyperlink is function is used | Excel Discussion (Misc queries) | |||
| How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
| file open via IE hyperlink causes already open files to shrink and tile | Setting up and Configuration of Excel | |||
![T_Yuri[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
