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

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

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

Is there any way to scale UserForm according to screen scaling? This code works for screen resolution, but it does not recognize screen scaling: With Me .StartUpPosition = 1 .Width = Application.Width * 0.85 .Height = Application.Height * 0.85 .Left =...

This thread lists 4 ways to post "small screen shots of your sheet(s)": https://www.mrexcel.com/forum/about-board/508133-attachments.html Are they only good for screen shots of cell ranges or can they be used for any screen object? I would like to post a screen show of the Name Manager...

Excel 2010 & 2016: I would like to open a selected workbook and see it on screen to be worked with. At present it only loads in the taskbar. Is there way to code this or do I use Sendkeys to make it 'active'?

Please can anyone tell me why using the screen updating control in a macro sometimes does not altogether eliminate screen updating? Thanks AP

Yes, I had a dream about Excel. I don't quite know what to think about that but I'm going to just go with it. :eeek: So I woke up 45 minutes late for work today (yup, off to a wonderful start) and remembered part of a dream I had about VBA and it won't leave my tired brain. Is it possible to...

Hi i have created a splash screen for my workbook but the workbook opens 20 other worksheets and starts to move information around between them. My splash screen then disappears to back with the original workbook i have run the macro from. Is there a way to bring the splash sceen to the front so...

For some reason, my Excel 2016 (64bit Office Professional Plus) is acting funky- recently redownloaded (new SSD in computer) 1. Whenever I open a workbook, excel opens but there is no workbook loaded or spreadsheet for that matter- so once it's open I either have to open a new sheet or open a...

I have several macros that run just fine on my desktop monitor but don't run at all on my laptop screen. There is no error message, they just don't run. They have the same resolution (1920x1080) but the laptop is 15.6" and the desktop is 22". What causes this and is there any way around it...

When I first visit the forum, I see the article list. Then suddenly I am redirected to the login screen, and I can only return to the article list after about fifteen seconds. Ugh. Then often I'll answer a question, spending ten minutes, taking screenshots, etc. I click on Post Quick Reply or...

there are three spreadsheets I use that I would love to be able to force to always open at a specift size [focus]. if a screen location could be specified as well that would be great. is this possible?

I'm using command buttons for process control in a spreadsheet. Using vba to enable and disable buttons to keep the user moving along. Each button performs a different vba routine. Problem I'm having is the buttons resizing themselves with each click. Specifically increasing in size, but the...

Does anyone know how to turn off screen updating in Excel VBA on a Mac? Application.Screenupdating = False doesn't work on a Mac. Thanks.

Greetings, I have a head scratcher that I am hoping you all can help me with. I am using an Excel worksheet on a 42" touch screen monitor as an information screen in our lobby. The WS is set at full screen and automatically updates with information on a regular basis, and visitors can also...

Dear All, I currently have a spreadsheet that will be copied and pasted into a power point presentation each time it is used. Is there a way to capture a screen print of a given cell range (A1:AE132) or what is currently on screen (Excluding the top ribbon, Formula bar and headings) using a VBA...

Hello, I wanted to adjust the row scroll when the following code runs. Sub search_a() Dim Fnd As Range Set Fnd = Range("H:H").Find("b*", , xlValues, xlWhole, , , False, False) If Not Fnd Is Nothing Then Cells(Fnd.Row, ActiveCell.Column).Activate End Sub the above code will take me...

Hello, I have a .xlsm - and if I freeze the screen with code, it makes errors. Everything is run from sheet "Mainscreen". My issue is it seems by freezing the screen, it does not give me all data. Only 2 of 8 rows it would give me without screen freezing, at most. It works perfectly...

I have code that sets the zoom level to match the PC that it is being displayed on. This works great so that ChartSheets fill up the screen for large sized external monitors down to small laptop screens. The issue is that my combobox dropdowns resize and move whenever I move from external...