Cannot Find Tools Menu
Feb 13, 2009I have installed Excel 2007 but cannot find the tools menu [or tab]? I see tabs like 'Home', 'Insert', 'Formulas', 'Data', etc. but no tools?
View 2 Replies
ADVERTISEMENT
Vba Code To Remove The Tools Menu
Sep 2, 2009Is there code available that will hide the Tools Menu within excel?
View 5 Replies View RelatedAssigning A Name To A Custom Button On The Tools Menu
Apr 3, 2007how to change the name of a Command Button that I have called "Command Button" on the Tools menu.
Also if I have this button created in my Personal workbook and I send the file to another user what should I do? Will that user be able to see this button ok?
Replace Standard Shortcut Menu With Custom Menu?
Jun 24, 2014I have created a sub to add new controls to the "Cell" shortcut menu. Can I remove the standard "Cell" shortcut menu controls? if so how do you do it?
[Code] ......
Menu Bar/Navigation :: Tool That Creates A Menu Bar Or Code?
Oct 20, 2009I have a workbook with multiple sheets. Is there a tool that creates a menu bar or code that I can add that would support navigation?
My goal is to have something with approximately 4 options (buttons?). They would link to 4 different sheets that serve as indexes within the workbook.
I know I can add a control like a button to a given sheet that would take the user to given sheet when clicked, but can I make the button 'float' above all the sheets, or add to a menu bar, or something? I just don't want to have to add the button to every sheet in the workbook.
I am looking for something simple/easy, and am not looking for anybody to do the work. I just have no idea on how to approach the problem.
EOMONTH - Tools / Add Ins
Oct 10, 2008I'm "missing something" here. I used the EOMONTH function in a recently developed workbook. In order to activate that function, I had to go to the Tools menu, select the Add Ins option and add the Analysis Toolpak to my Excel configuration ... no problem, worked like a charm. Then I sent the workbook to another user. Of course, the EOMONTH function came up with errors when she opened it. I talked her through the Tools/AddIns/Analysis Tookpak configuration change ... but could not get the EOMONTH formula to work.
View 5 Replies View RelatedDisabled Tools
Jan 21, 2010Just discovered the drawing tools on my quick access tool bar are disabled. All were enabled and working fine just yesterday. I'm running 07 on xp. I've shut down and rebooted, no change. Need to know how this could have happened but mostly, how to enable.
Set Tools/Options From VBA
Jun 27, 2006I use several different workbooks during the day, and sometimes I would prefer the " move selection after enter direction" option to = "Right" and sometimes "Down". It doesn't seem to be an option that is saved with the workbook.
what could be done to a workbooks code to change this option upon opening the book?
Add-in Not Showing Under Tools | Add-ins
Oct 31, 2006I placed an add-in (.xla file) with a " function" and a "sub" into C:Microsoft Office XPOffice10Library. When I go to Tools-->Add-Ins the Add-In doesn't show up. When I browse the file it says it already exists and still doesn't show up. The strange thing is that the "function" does work, but the sub (which is a sub worksheet_change) doesn't run. I also tried doing the steps as they are laid out in http://www.ozgrid.com/VBA/excel-add-in-create.htm and ended up with the same problem. The function works when I open up a brand new Excel application and use Book1, so I know the function isn't embedded in the sheet.
View 4 Replies View RelatedDrop Down Menu: Add Another Selection To The Menu List
Oct 18, 2008I have a column with various drop down menu boxes and I need to add another selection to the menu list. My problem is, it's been so long since I did the drop downs, I have forgotten how to do it..
View 3 Replies View RelatedMenu Pathing (execute The Macro From Menu)
Jul 2, 2009I'm adding a menu selection to the right-click menu that you get for cells. I can add and remove the menu option but, when I try to execute the macro tied to the menu, I get "the macro...cannot be found". I can't figure out what appears to be a "pathing problem". I'm sure it's simple but...
Here's the
Window Menu In The Main Menu Bar Deleted
Mar 27, 2009I have actually got the Window menu in the Main Menu Bar of excel deleted using below command.
Application.CommandBars("Worksheet Menu Bar").Controls("Window").Delete
Menu Structure: Opens A Menu Next To It With Different Options
Jul 15, 2006Now this is something which I dont even know if it can be done, but its something which I would use, a lot. When clicking on a button, like a normal button from the control toolbox, is it possible to open a menu from this? So I click on the button i made called "accounts" and this opens a menu next to it with different options.
View 5 Replies View RelatedChart Menu Bar Won't Change To Data Menu Bar
Apr 26, 2007my worksheet menu bar is displaying the ' Chart' menu no matter what I do. Not only do I have no charts in the workbook, (verified this by: )
For Each ws In Worksheets
ws.Select
MsgBox ActiveSheet.ChartObjects.Count
Next ws
but adding worksheets, selecting various parts of a worksheet, creating a chart and deleting it, and everything else I've tried has no effect.
One interesting thing - the first chart I added (to test if it would 'unstick' itself upon deletion of the new chart) was named 'Chart 2', implying there was a chart1 that existed previously.... although I am fairly certain I never added a chart to this workbook at any point.
Also, the menu bar is working fine in other workbooks, and changes to chart and back to data like normal.
Macro Not Showing In Tools
Feb 5, 2010Why when I open some files that have macros and I enable macros on initial opening and then go to tools-macro-macros it's not showing anything there, but when I press Alt F11 then I can see macros?
Is there any way to change this that I can see all macros from tools-macro-macros?
Add-in Created; And Added Via Tools, Add-in
Jan 25, 2008I've created and excel spreadsheet that has code like this in a Module named Print w/ in the workbook:
Sub Print_wsPrint()
Sheets("Print").PrintOut
End Sub
I have saved it as an MS Office Excel add-in.
I added the add-in to my excel environment via Tools, Add ins...and let it copy it to my C:Documents and SettingsjohnApplication DataMicrosoftAddIns directory.
But yet when I create a menu button and assign the Print_wsPrint to a custom menu, it complains and says "The macro Model.xls!Print_wsPrint cannot be found," where Model.xls is the workbook I am in. It's in my add-in, not in the current wb.
Tools . Options Not Working
May 2, 2006When I choose tools -----> options from the menu bar nothing happen I can not changes my options. I am using excel 2000, I must of changes something but I don't not remember what. Can someone help turn back this option
View 9 Replies View RelatedVBA Code For Extract Report From Tools?
May 1, 2014VBA code to extract excel report from tools e.g. SAP or other tools.
View 3 Replies View RelatedHiding & Unhiding Tools / Macros
Jan 26, 2007I want to hide and unhide tool / macros menu so that users don't run the macros in the workbooks.
VBA Code To Change Tools-references
Feb 25, 2008I am setting up VBA code to create different excel workbooks. One of the differences is in the VBA Tools References that must be enabled to make the whole thing function.
How do I write VBA code to turn on and off specific tool references ie. if i had a reference called OrbitCOM Library how can I turn it on and off using VBA code.
Tools & Format Options Cause Freeze
Nov 21, 2006On one of my computers, Excel is freezing up just about any time I select something from the Tools or Format Menus (same goes if I use keyboard shortcuts to call any of those things). I have to kill it with the task manager. It is not a specific workbook, I've tried several, including new blank workbooks.
It's not all menus, as File options seem to work. I also am able to Autosize columns by double clicking, but basically any other formatting things (i.e. CTRL + 1) do not work. I also tried to show the Cell Format dialog via VBA, (note: I am able to get to VBA editor, etc...), and it locked it up then too.
Finally, I tried "Detect & Repair" from the Office disk, but that didn't do anything. Next, if necessary, I'll do a full re-install unless anybody else has heard of this and knows what the problem is.
VBA Print Preview And Control Toolbox Tools
Dec 9, 2008I have a spreadsheet with check boxes and a combo box that are set to display in print preview as well as print. I have set up a Print Preview button on this spreadsheet, as well. When you click the Print Preview button and then click close on the preview window and return to the spreadsheet, the control toolbox tools appear out of place and are greatly magnified. Scrolling the screen down and then back makes them appear correctly once again.
I have seen this on this spreadsheet on three different computers. Does anyone have a clue what is going on?
Note, clicking the print preview button on the standard toolbar does not provide the same artifact. It works correctly.
Or for the cheap fix, what is the VB script to move the cursor to a different cell and then return back?
Circling Text Within A Cell Without Drawing Tools
Mar 10, 2009I can't find anywhere where there may be some VB code to allow text within a cell in Excel to be circled. I don't want drawing objects, because many times I need to modify 30-40 sheets at one time and Excel doesn't allow you to alter drawing objects when you have multiple sheets selected. Therefore, I just want to be able to apply a circle around some text in a cell the same way you would underline it, for example. I figured my only hope is VBScript?
View 9 Replies View RelatedChanging Application Tools Options Chart
May 17, 2006how can I change via VBA the chart options in tools--> options-->charts
View 4 Replies View RelatedPerform Data Analysis Using Automated Tools
Oct 4, 2006i am preparing my self to enter the microsoft Excel 2003 Exam.....
one of the mentioned points in the preparation list is: (Perform data analysis using automated tools) how to use the automated tools? and if possiable to get a file that i can apply these tools on it
Formula Not Updating: Using Tools, Options, Calculation, Automatic
Oct 27, 2006I have a table with rows that keep growing. But I have place formula in the whole of column F, i.e. F2:F66565. When I import information from MS Access into column A to E, the formula in F does not work, until I copy from F2 to the end manually. I have tried using Tools, Options, Calculation, Automatic. That doesn't work, I have also tried F9, that doesn't work and I have also tried checking Precision as Displayed under the calculation tax in Tools-Options, that doesn't work either.
View 3 Replies View RelatedCounting Menu Items In Menu Bar
May 20, 2006Suppose I delete a (unknown) number of items from the Worksheet Menu Bar. This can vary because of the fact that my excel sheet is being used by a different number of people, all with a different Worksheet Menu Bar configuration. Is there a way of counting how many Menu items are still left in the Worksheet Menu Bar?
So, suppose all that is left (after using the program) in the Worksheet Menu Bar are Excel, File, Tools, Help. How can the porgram find out that there are only 4 items in the menu?
Sub-Menu Not Showing On Toolbar Menu
Jul 8, 2007I am taking an EXCEL(online) class and in my current assignment i am to create a 'list' for sorting and querying. However i cannot find the 'list' option, under my DATA option on the toolbar. I have tried all my toolbars and shortcuts but I am unable to find it anywhere.
View 9 Replies View RelatedAddin Under A Menu Of Menu Bar
Jun 21, 2007I have made an excel addin named "INDNUMFOR" and want that this should display under "Data" of main menu bar. thus, a new item (sub menu) should appear naed "IndNumFor" under Data main menu.
View 9 Replies View RelatedDate Format- Data Retrieved Via Import Data Tools
Feb 4, 2009I have the following data retrieved via import data tools ...
View 9 Replies View Related