1. B

    Excel closes wrong instance

    Sometimes when I have two excel workbooks open, If I click the cross on one to close it, the wrong workbook closes without saving. This even happens when the excel closed is on a different screen to the one I have closed. Any ideas what could cause this? Many thanks!!
  2. E

    i need some help in userform

    i want a code to make auto-update to the userform screen so when anythinh changes in the excel sheet it happens immediately in the userform screen
  3. T

    Posting Screen Prints to Questions

    I have a basic question that I haven't figured out. How do I post (paste) a screen print to a message I am posting? I see the Insert Image icon in the ribbon, but when selected it prompts for a URL. How do I post a picture stored locally on my computer to the question I am posting? Thank you...
  4. T

    Macro to open a sheet in a new window

    Hi Everyone, Hope you can help I want a macro that can open a sheet in a new window. Idealy it would do this. When macro is run open Sheet"PDF Views" in new window and if possible? place new window in middle of screen taking up about 75% of the screen make that screen not show any tabs or...
  5. rjplante

    Open and space two folders

    I would like to open two windows folders on the screen and have them appear side by side on the monitor. I have the code below to open both folders and that part works fine. I just need to know how to size them and move one to the left side of the screen and one to the right side of the screen...
  6. D

    Keeping open the notepad

    Hey guyz, I am working on VBA environment, would like to keep my notepad open all the time without switching the active screen. Is there any way we can do this ? Dinesh S
  7. T

    Rounding in CONCATENATE

    Hello, I can´t solve the issue with CONCATENATE and rounding in this function like this screen: I need to round it only to 2 numbers after the decimal point (examlpe: 7.13%, not 7.15615615686164489%) Can anyone help me with this function to solve it? PS: Function is...
  8. L

    Create hyperlink via userform

    Hi all Not sure what is going on with this, I need my code to add a user selected hyperlink through the dialogue box, into a table on a different worksheet. I don't want to overwrite the current cell value with the screen tip either, What it is doing, is adding the root part of the hyperlink...
  9. V

    Excel not responding when run macro on the shared workbook

    Need help on below. Basically, I want to combine all the data from worksheets into one worksheet. And this workbook is shared and will be used by multiple users at the same time and save the files before combine. However, when run the macro, it is not responding. Code: Sub Combine() Dim J...
  10. G

    Stop Excel from Opening in Full Screen Mode (Office 365)

    I have Office 365. Whenever I start Excel or open a new file with Excel, it opens (or goes to) full screen mode. I can find no way to stop this from happening. Any ideas?
  11. T

    Worksheets - Automatic Resizing

    Good Morning I need to understand how to write macros to automatically resize worksheets to display the same on all computer screen sizes. theamateur1939
  12. D

    Can you freeze from a certain cell when that cell gets to the top of the page

    I have a spreadsheet that has a rather large logo at the top. The logo is of where I work and I want the screen to rows 5:10 to free at the top of the screen so they will always be visible but anything above row 5, I want to scroll up as you go down the page. How do I do this?
  13. S

    Drill down by Week

    Hi All, I have a problem with the line chart i,e I am unable to show the data by week wise but I can able to see by day wise. Please help me to show the data by week and day wise like the below screen shot. Please check the my output: I used my order data for my axis and I can see by...
  14. J

    Missing Main Toolbar Excel 2010

    I cannot determine how to show my main toolbar. I can see my add-ins toolbar but not the original toolbar. Help is appreciated. I tried CRTL+F1 but all I get is a help screen. Thanks,
  15. A

    Excel crashing

    Folks, I have inherited a report which is causing me some grief. Originally, in .xlsm format it comes in at a hefty 300mb but its only 38000kb in .xlsb. So its not a large file. there are a handful of simple pivots stemming from source data held in dynamic named ranges, and a few navigational...
  16. 6

    How to show a full screen JPG

    How can I open a full screen JPG in VBA?
  17. rjbinney

    Recommended File Appearing on Home Screen

    This recently appeared, and I can't put my finger if it was before or after my HD crashed... When I launch Excel and hit Alt+F (Windows 10), it brings up the "Home" screen. (Not the Home TAB, the Home SCREEN. Argh, Microsoft!) Underneath the templates, and the list of recently-used files, I'm...
  18. S

    Subtracting a column in pivot able

    I have a pivot table & I'm trying to get a difference from two columns within the pivot table. This is a screen shot of pivot table. [Imgur]( This is a screen shot of the fields selected. [Imgur]( I've tried adding a...
  19. E

    Excel refuses to open some workbooks, blank screen.

    Excel is refusing to open some workbooks, showing a blank screen. If I go to immediate window workbooks.count = 1 (personal.xlsb, not the xlsx), the workbook is not show in unhide option. The workaround I found to work is open a workbook (not the problematic), open the problematic workbook, go...
  20. M

    How to get data from Excel online

    I have a datasource stored on an Excel on Onedrive Business (ie Excel online). In a local machine Excel, I goto Data > Get Data > From Web and enter the correct path of this Excel online file. At first there is a screen for me to select organizational account but I selected cancel. Then, I...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...