clicking

  1. M

    vba + html - accessing tab on website not working

    Hello all, When Im in the site, there are 2 tabs - wathlists and quotelists. Quotelists is the default. When I put the simple link to watchlists it pops up and then ends up jumping back to the main page: objIE.navigate "https://www... I have also tried clicking the tab but Im still new to...
  2. V

    Open image XXXX.png where XXXX is the cell value?

    What is the simpliest way to open up an image from specified folder. Where image name is cell value by clicking the cell. For example: I have 0123 value in A1 cell. And subfolder \pics\ in my work folder and there is a 0123.png file in pics folder. So How I can open this image by clicking the...
  3. L

    Put "x" in Cell

    Hello is there a way to have a column that when clicking on a cell in that column, an "x" is inserted and clicking again clears it? My table on that sheet column starts at row 7 if that matters. Thank you very much for your help
  4. K

    Automatically Consolidate Data in Excel that has Multiple Duplicate Values

    Hi All, So I just watched this video, and it did exactly what I needed it to do! However, I'd like it to do it automatically... is there a way to make this data consolidate when I'm done typing, instead of clicking through the Data > Consolidate THANK YOU!
  5. F

    Issue allowing users to copy chart but forbidding to cut it

    I have an excel sheet containing several charts & tables, the sheet is protected and all charts are locked. I would like to make it possible for the users to copy the charts. Either by right clicking and selecting copy or by triggering a macro at when clicking or double clicking a chart. I've...
  6. M

    Pasting into here from Word

    Why cant I copy text from a WORD document into here ? Ive tried clicking the PASTE FROM WORD button above.
  7. E

    Excel 2010

    I'm fanatic user of Excel 2003, using VBA coding with no problems. I try now to work with Excel 2010 but facing problems with the "title bar" and the resizing of the sheet when double clicking the title bar. Is any VBA code to remove the "title bar" and disable the double clicking on it? I...
  8. I

    Insert Row by Double Clicking

    Hello I use this VBA code to insert rows in active sheet just by double clicking a cell (doesn't matter which cell) Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Application.ScreenUpdating = False Cancel = True Target.Offset(1).EntireRow.Insert...
  9. R

    Creating "Approve" cells in excel checklist

    Hi, I have checki, which is digitaly signed at the bottom, as an end of day validation. However, there are several intraday tasks that have to be "approved". I've previously seen a document where by double clicking a cell it would add our pc login username to that cell. Does anyone know how...
  10. B

    How to select one row in a continuous form?

    I have a continuous form. where i have a button. when i press that button, i want that row in the continuous form to be selected. i want that rows first textbox to get focus. so how to select or setfocus to the row im clicking on, when clicking a specific button?
  11. L

    de-select the whole sheet

    Hi I can select the hole sheet by clicking on the icon on top left corner. How can I deselect a sheet with out clicking on any cell? the reason I want to know because I am recording macro that will select and delete the whole sheet then deselect. Thank you
  12. S

    Multiple Separate Excel Instances

    I do not like the way Excel includes all open workbooks in a single instance of Excel. There are times when I need them completely separate. I can do it by typing Excel /x in the command. But is there a way to start a separate instance of Excel by clicking the icon and holding a key? I have...
  13. D

    Multiple Dropdown lists in a sheet with hyperlinks

    Hello all, I have approx. 100 company names in the "Summary" sheet and a corresponding spread sheet for every company (These are hidden and are activated via hyperlink attached to the name of the company, i.e. by clicking "Company A" cell in "Summary" it opens "Company A" sheet etc.) What I am...
  14. keldsor

    Seleting objects instead of cells ??

    I have a workbook with a worksheet with a lot of shapes like DOT. Each dot represents an event and I can get the details for a specific event shown in Word by double clicking on the DOT for the event I want to see the details for. I HAVE to do "double clicking" for the details to show up in...
  15. D

    Selecting the autocomplete cell name? How do I do it?

    I am writing formulas that reference cells with defined names (for Example "First_Exterior_Wall_LF") and when I start typing the cell name into the formula window it drops down a little autocomplete (so I type "First_E" and the proper cell is listed right below), but I can't seem to select or...
  16. M

    Expanded rows not saving?

    Hey guys, I just received this sheet and after widening the rows to see all text and clicking save as, closing then reopening it still shows as attached, help please? https://s10.postimg.org/4ku1mmaw9/Screenshot_1.png
  17. H

    show/hide comment menu does not appear when right clicking on cell

    I have set up a comment on a particular workbook, but when right clicking on the cell containing the comment, the show/hide comments does not appear on the menu when right clicking I works on my other workbooks It would be appreciated if someone could assist me in resolving this
  18. M

    Selecting Entire Row by Clicking a Cell

    Hello Guys, I want to select entire row if i click on the any of the cell in that row. Is this possible?
  19. J

    Acknowledgement Pop-Up or Button

    I am brand new to macros so please feel free to dumb this down as much as you want. I am beginning a new position and am revamping the timesheet process, which is done with Excel. There is an issue with incorrect time reporting, and I would like to create either a pop-up or yes/no button that...
  20. V

    Hyperlinking Buttons

    Is it possible to dynamically assign a hyperlink to a button, based on the value of a cell. That is, so that clicking on a button links to a URL defined in a given cell? Thank you!

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top