screen

Hello, I have multiple hyperlink in a tab to jump to specific cells that are far away(to avoid scrolling). When I use them, it moves the screen until that cell isjust barely showing, usually in the far right hand side. Can I possibly have itso the cell gets centered on my screen? Thanks,

Morning, Long time reader, first time poster. Looking for some help with a formula, or If it is even possible. I have a sheet that is a summary overview screen. It pullsdata using drop down list from other sheets to display financial performance. The summary screen shows the 11 key...

Hi Everyone, Ok so I've never had this before and I can not work out why its happening? I have a document with several sheets. On one sheets called master I have conditinal formating to show hide some cells by changing there colour (I say hide but besicly back ground is white so if I don't...

using this code I am able to have a hyperlink (not active, nothing happens when you click on it) so that it shows a "screen tip" (showing the 'date of hire'. This is for an Org chart I am working on.) But i only can get it to work with 1 object. Will I have to have a separate macro for each...

I've written a macro that takes the User to a web site; unfortunately it opens in less than full screen. Is there a macro command to expand to full screen ? TonyGreyHd

Hi, Is there code to show the print screen as if you went to file and print from the menu? I tried the "(xlDialogPrint).Show", but that doesn't show all of the options such as fit to page, landscape, etc. Thanks

Hi all, I am currently going through the process of making charts dynamic by using named ranges and the OFFSET function. Most of our charts show 13 months and I have achieved that with a named range called Months_13 which is defined as below. =OFFSET('Input Screen With...

Hi all, I don't tend to use a lot of charts but have been tasked with the job of making our chart ranges on an accounting spreadsheet update automatically. I have searched all over and thought I had it figured out but for some reason it's not working for me. I would be most grateful of any...

Hello, I have a userform which Height"1080" , Width"1920" and with below code when its populated if I run the whole code, the background picture doesn't fit at the screen even though picture size is 1080*1920. The reason of that size is I'm going to use that userform at the big screen tv. Is...

Hello. I am running Excel 2013 on W7 Pro 64bit. I have just recently noticed (when I came back to it after quite a few months) that the configuration of my VBA editor screen had changed. I would like to get it back to the neat way of having the code editor as the largest pane, and the immediate...

I have a spreadsheet that contains many many rows and quite a few columns....Their are far to many rows to try to get them to fit on one screen but the columns can be. I created this spreadsheet on an external monitor but now they do not fit on my laptop. I have seen ways to do autofit but...

I have an Excel 2016 VBA macro for processing a large volume of data. The macro can take up to 14 minutes to run due to the volume of data. I have used the usual methods for speeding up the macro which means screen refresh is switched off. So when the macro is running I do not know if all is...

Hi, I have a spreadsheet written in Excel 2013 in Windows 7 at 1920x1080 with a userform that fits my screen perfectly (Height = 725, Width = 1161). Recently installed Excel 2016 in Windows 10 and ran the userform and it's quite a bit larger - so much so that information on the bottom of the...

I currently use the code below to center the userform in the center of the screen. All works good. With UserForm1 .StartUpPosition = 0 .Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width) .Top = Application.Top + (0.5 * Application.Height) - (0.5 * .Height) .Show End...

Hi Team, I have an requirement where i need to move the mouse cursor to to particular element on the screen. I tried to look the code but only able to find the code by setcursorposition where in you need to have the coordinates. Is there any possibility that we can move mouse cursor without...

Hi all On Sheet1 I have a Picture. When workbook is opened for first time I would like Sheet1 to be selected and then the Picture to be resized automatically to fit the entire screen regardless of the screen size. is this possible with VBA, if so how ?? Many thanks in advance

Hi all, I have a sheet called 'Year 8'. In that sheet I have .... * 25 student names in the range B6:B107 ... each student has 4 rows allocated to them, example, student A has data from C6:AV9 * student results from C6:AV107 * Column Headings in the range B5:AV5 I'd like to have a single...

I have written some code where it will turn on screen updating just long enough to input a text value into a cell that explains to the user what the current status is for the procedure. Once the status is inputted into the cell, I then the VBA turns off screen updating so that the rest of the...

Hi everyone, I have a document that works great and has a macro that makes it full screen. (See Below) however I found on opening other Excel documents the Full screen comands below stayed, so I've been switching full screen off when the Document closes (see below) My problem is this. If I...

Hi All, In calling xlDialogPrinterSetup from: Sub PromptPrinter() If Application.Dialogs(xlDialogPrinterSetup).Show = True Then Sheets("Data").PrintOut From:=1, To:=12 End Sub When the PrintOut dialog icon is then presented on the screen, if a user cancels this portion of the sub's...