screen

So I have been having this same problem for a long time. I just work around it, by scrolling with my mouse, which can be tedious. We used to have MS 2016, now we have Office 365. Problem existed on both. The document is a shared document, old school, not the internet sharing because I need to be...

Hi All, I have a PowerBi that recently started displaying incorrectly. I just swapped my laptop too, and have the same issue, so it's an issue within PowerBi and I don't know how to solve it. The menu's and top of the screen layout has disappeared and it makes it hard to work with I've got...

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!!

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

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...

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...

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...

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

Hello, I can´t solve the issue with CONCATENATE and rounding in this function like this screen: https://ctrlv.cz/oEeL. 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...

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...

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...

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?

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

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?

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...

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,

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...

How can I open a full screen JPG in VBA?

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...

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](https://i.imgur.com/iUyA5F2.png) This is a screen shot of the fields selected. [Imgur](https://i.imgur.com/wjl25eZ.png) I've tried adding a...