colleagues

  1. I

    Keyboard Shortcut changed from Today to Ellipsis

    Hi All Randomly my excel has changed CTRL + ; from todays date to ... When i go into options there is no option for keyboard shortcuts. Has anyone any ideas how to revert this back? Checked a colleagues version and only difference I have is having fuzzy lookup installed. Thanks!
  2. J

    How to auto-fill textbox using VBA

    I currently have a VBA form (a worksheet with some text boxes) that lets me easily input requests sent by different colleagues, however one annoying part is that I have to always copy and paste my colleagues' name (which most of them are common "customers"). Therefore, I would like to ask is it...
  3. H

    Excel form resizing according to screen resolution

    Hello All, I have an excel-vba userform that has some checkboxes, lables and buttons. I have given the specific height and width for the form which is almost 3/4 th size of my Screen. This form is used by my colleagues with different Screen resolutions. For few of my colleagues, the form is too...
  4. J

    Invalid Call or Procedure... Sporadic Happenings!

    Good morning all! I’m after a bit of advice, as my issue is one I’ve neverexperienced until recently, and one that has personally never happened to me,but instead around 20% of my colleagues. I’ll explain below, but won’t post thevba unless necessary as it’s very long, and there’s no debug...
  5. L

    Overlapping Times and Date

    Hello all, As ever, i wondering if anyone can help with a problem i am having. In columns B & C of the attached i have some times and dates where we asked colleagues to work at short notice. In columns E & F is the time colleagues actually worked. I would like to take each instance of when...
  6. C

    Macro changes cell colour for some colleagues when run

    Hi, I have a macro in a workbook that other colleagues use. Part of the macro copies the data into a new workbook. Most have no issue, but with a few colleagues it changes the cell colour (Red, Accent 2, Lighter 60% in the cell colour pallette [R230, G184, B183]) to a sort of orange...
  7. M

    Macro to default particular workbook to US number convention (ie, X,XXX.00)

    I have a file that was prepared by me using the correct (:laugh:) number convention of £X,XXX.00 however my European colleagues prefer to use X.XXX,00. Typically Windows and/or Excel would override these preferences and reset to the user defaults, however my workbook has numerous examples where...
  8. B

    Identifying lastest/Lst Update in a list

    I have created a log where colleagues go in to update their preferences. What i am looking to do is identify what line is the last update for any/all of the colleagues who have filled in. As below i am looking to identify as i have in column C the line where these colleagues last updated? Any...
  9. C

    F4 cell reference toggle shortcut not working anymore.

    Has this happened to anyone else? I am using the same computer and version of Excel as I have when it worked previously. It didn't work yesterday either. My computer was updated over Christmas, but my colleagues are not having the same problem.
  10. C

    Use folder to open excel

    Hi, I have an excel workbook that contains a userform. In this userform, the user has the possibility to open several other documents that I have created. I would like to be able to share this with my colleagues and do so in the following way: Create a folder where I can copy all the...
  11. C

    Type in a name and it lists their manager.

    Hi, I'm trying to set up some function that will allow me to type in a colleague's name and it pulls up his or her manager. Appreciate any assistance in this. Thanks 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