Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
QN: Refresh???
I ran one of John W. macros from his CD in his book, and now I have a
REFRESH Toolbar that I cannot get rid of??? I searched all over, and cannot find anything to get rid of it. I double clicked it and it is up now in the menu bars. I click on the toolbar options, and it lists all the options, but nothing to get rid of this toolbar. Any ideas??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
QN: Refresh???
Try right clicking anywhere in the toolbars. You should get a list of all of
the active toolbars. Uncheck the Refresh toolbar... Hope that works... "Michael Vaughan" wrote: I ran one of John W. macros from his CD in his book, and now I have a REFRESH Toolbar that I cannot get rid of??? I searched all over, and cannot find anything to get rid of it. I double clicked it and it is up now in the menu bars. I click on the toolbar options, and it lists all the options, but nothing to get rid of this toolbar. Any ideas??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
QN: Refresh???
vew/tollbar option/customize/
and them drag the refresh toolbar menu outside the toolbar that keep this menubar. if this does not work, probably you have one add-in, unistall it fro tools/ add-i -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
QN: Refresh???
Sorry!!!!!
TRy this but beware because I am using the spanish version and don't know th toolbar name "if is refresh, no problem use the following macro" Sub Toolbars_Hide() Dim TB As CommandBar Dim TBNum As Integer Dim X As Byte Application.ScreenUpdating = False 'Hide all visible toolbars and store their names TBNum = 0 X = 0 For Each TB In CommandBars If TB.Type = msoBarTypeNormal Then If TB.Visible Then if lcase(TB.Name) = "refresh" then TB.Enabled = True '.Delete end if End If End If Next TB End Su -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
QN: Refresh???
Well, that is the problem. When I do that... I don't see an option for
"Refresh"??? I have tried all your suggestions, and that stupid toolbar is still there??? I can't get rid of it. It just says, "REFRESH", and then below it, it says, "Do Not Refresh". When I right click on it, it gives me all the options such as: Standard, Formatting, Borders, Chart, ToolBox Menu and so on. What can I do to get rid of this thing?? Michael "Andoni " wrote in message ... vew/tollbar option/customize/ and them drag the refresh toolbar menu outside the toolbar that keeps this menubar. if this does not work, probably you have one add-in, unistall it from tools/ add-in --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Excel functions formula and auto refresh refresh | Excel Worksheet Functions | |||
Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming | |||
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming |