I've no idea what combination of keys I hit to do this, but when I hit the / key it's highlighting the 'File' menu - working as though I pressed Alt.
Unlike Alt though, it doesn't un-highlight it if I press / again.
It only does it in Excel - Word works fine, as does notepad and obviously I can enter it on here to.
I've tried rebooting, but it's still there.
I found this spreadsheet on here and I have been trying to customize it to what I need. I am trying to have scores from skins match highlighted. I want only the minimum score to be highlighted but if there is another duplicate minimum score I don't want it to highlight anything. I also need to find a way to count the skins won by each player and have it off to the side.
For those not familiar with golf a Skin is a game where you try to get the lowest amount of strokes on a specific hole. Ex- 4 people play the hole one. P1 scores 4, P2 gets a 3, P3 and P4 get 6. The skin would go to P2 who has the lowest score on that hole.
Highlight lowest number in each column not highlighting if there are duplicates starting at L6 down to L11 and for each column till AC. And the same for the group just to the right on attached file.
On row 13 and 14 it tells me who won a skin. I want to tally up the total skins won by each player. so if Joe's names shows up twice on R14 I want it to tell me somewhere in the sheet Joe = 2
how to hide/disable/grey out the excel logo in the top left corner of the screen. directly to the left of the file menu.
i am trying to close all ways of accessing the VB editor.
I have 2 worksheet in excel, first worksheet called "inventory", and second worksheet called "consumption".
The inventory worksheet is the big list of items that we have in store(ex: apple, mango, grape, orange, carrot, banana etc up to 200 items).
In this worksheet, coloumn A is the item name, and coloumn B is the quantity. in some cases, we dont have all the item in the inventory, for example only 50 items that having the quantity (other items is 0)
In the worksheet "consumption", it also have coloumn A with item's name and coloumn B with quantity.
In Consumption worksheet, i want to create a dropdown list in coloumn A, that automatically only populate the items that we have in the inventory worksheet (50 items) (not showing all items (200 ea) in dropdown list).
I 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] ......
I 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.
I 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 RelatedI'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
I 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
Now 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 Relatedmy 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.
Suppose 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?
I 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 RelatedI 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 RelatedHow do I disable the "Save" option from File Menu and allow only to "Save as"?
Excel 97/2000
I have a column "A" with a cell for each week's income (A-1 thru A-52).
Is there a way to program these 52 cells so that the cells reflecting the "maximum" and the "minimum" amounts of weekly income, would be automatically highlighted in some way? Of course the "minimum" would have to be able to not use the cells representing the weeks that have not occurred yet. These cells will also need to be able to change automatically as weekly income amounts change.
I am interested in finding out how I can highlight the row I am currently working in? When I move rows, I want the highlighting to move to the appropriate row.
View 9 Replies View RelatedI've a large spreadsheet packed full of values, and % variences etc etc
My boss has tasked me to try and highlight each week the major changes from the week before.
The whole spreadsheet is full of vlookups based on a cell - Z3 in this case. Cell Z3 is a week number, and when i change that, everything is updated based on a load of other sheets.
Is there a quick and easy cheatuing way using some code that i can analyse all the changes from what the values were before, to what they are now, and highlight the major movers?
I have created a data base of all the spare parts we have at work.
In the last column I have entered a hyperlinks that take you to a layout of the store and shows you where the part is located i.e. – 1C would take you to shelf ‘1’ level ‘C’ on the drawing in another tab in the same Excel workbook.
I would be pleased if anyone could help me by suggesting away that I can make the destination cell highlighted or more prominent once you have clicked on the link.
Also can I make the Find window automatically appear when the workbook is first opened?
I have a worksheet, the data flows from different columns, like a,b,c and the result is in d column. The entries are spread from 1 to 45 rows. The format of data is five digit number. As I have formatted the cells as "custom" like "00000", the Zero is shown on left side, but when the column is copied/pasted in another column in certain entries zero disappears. Is there any way to get the 4 digit entries, highlighted, so Zero can be added on left side manually directly to the concerned entries, instead of checking each and every entry.
View 4 Replies View RelatedThis problem has been driving me insane, as I thought it wasn't possible to do in excel however this morning I accidentally pressed a shortcut key on my keyboard and what I wanted, happened.. pity I can't remember how I did it.
How do I highlight an entire row, but remains highlighted when i enter info in the cells until i move down to the next cell? Eg. I click on row"1" so that all cells are highlighted, then while entering info in B:1 - the entire row is still highlighted? This will be very useful in my line of work.
I know there was some information on conditioning formatting, but surely there is a way to do it via keyboard shortcut since i accidentally did it just before.
I have the following code:
[Code]....
Which is conducting a wildcard search of roughly 15,000 rows of data. It is a wildcard search comprised of street names. So, if a user types "Wood" in ComboBox1, it may return Woodmont, Northwood, or any other combination. Is there a way, when the search results are populated, to highlight only the "wood" (in this case) part of the response?
I can not figure out why only the color index 5 and 8 are working in the example- (1). To tun it say "no" to the initial prompt that comes up and select 1 from the dropdown in A2. Before some additional functionality was added it was called TestBook and that highlighted appropriately.
View 2 Replies View RelatedI have attached a sample sheet which is for invigilation of exams. In columns D, E & F are the initials of people invigilating at different times. What I want to able to do is to print personised sheets for each person where there initals are in bold and the box has a black border around it. This is very labour intensive if I do it manually as have to highlight one person, print, unhighlight and rehighlight the next person and so on. What I was wondering is could I use a macro to automate this process. So it has a list of all the initals and it searches through and highlights the person and prints it and then moves onto the next.
View 14 Replies View RelatedI have this module code in VB:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Application.ScreenUpdating = True
End Sub
Conditional formatting rule applied to range.
=CELL("row")=ROW()
This highlight's the row yellow when a cell in that row is clicked, however it only highlights the row when you refresh the page by scrolling off the cell and back again. It just feels a bit flaky.
Is there a way I could loop through a range and when a condition is met highlight the NEXT ROW in a different colour
For example if C10 houses the number 5 then highlight NOT the row with C10 in it but the NEXT row...
I have a spreadsheet that I need to highlight the last row next to the name in column E where the date in column C is 35 days or less than the current date in cell A2.
For eg if there are 10 names containing the name "James" in Column E and the last date in column C (say C20) in line with James is 35 days or less than the current date in A2, then the entire row from A to G for eg A20:F20 must be highlighted in grey.
I need VBA code that will do this for me.
I have attached in sample spreadshhet. In the attached example A14:G14 and A16:G16 must be highlighted in grey
I have a spreadsheet with one column. For example, it contains
A
A
A
A
B
B
C
C
C
D
D
I want to highlight the A's and don't highlight the B's and then highlight the C's and then don't highlight the D's and so on. I want to highlight or not highlight the entire row.
how can I highlight any value that is duplicated within the same sorted value?
Example:
I sort column B so that all the names are in order. In column F I want them to be highlighted when there is duplicate name within the same sorted names of B.
I have a column with yes/no. How would I make it so that it would highlight the row if the value is yes and do nothing if it is no? Would I use a for statement.