maximize

Finally, there is an updated and legitimate way to require macros, which I will share with you here and stumbled upon via trial of various methods. The common methods found online, such as toggling worksheets visibility, are flawed at best. INTRODUCING, the very simple yet effective...

Hello, I am not sure if it is possible to do in Excel, but is there a formula or way to use Solver to allocate based on the selling price, and is contingent upon (1) the allocated amount must be less than or equal to the capacity, and (2) the sum of the allocated amount by part number must be...

I am attempting in the code below so when I run the macro it will zoom to 50 and minimize then when I run the macro again it will zoom to 90 and maximize. Please help me get the code correct. Thanks as always Sub ribb_zoom() CommandBars.ExecuteMso "MinimizeRibbon" ActiveWindow.zoom =...

Hi, how can i modify the code below in Outlook that when file opens in Excel is in maximize window. Public Sub OpenVendorChartofAcounts() Dim xExcelFile As String Dim xExcelApp As Excel.Application Dim xWb As Excel.Workbook Dim xWs As Excel.Worksheet Dim xExcelRange As...

Looking for code to see if a folder is open if it is maximize it? If its not Open open it?

Take a look at this... From a userform. I call a macro that opens a workbook called Training_Priority. After it opens I can't close it unless I minimize then maximize it. Then I can close it. What is up with that? Private Sub CommandButton6_Click()Unload Me Call Priority End Sub Sub...

The picture below shows a simple example of the problem I'm facing. I'd like to maximize a cell that is the sum of other cells that are not linear. In the spreadsheet, I have Z scores for categories I and II (I hardcoded in a mean of 30 and stdev of 15 for category I and 40 and 10 for category...

Hi, I have workbook that I would like to bring to the foreground and activate when I press an assigned shortcut key (even if the workbook isn't active). The idea is that the workbook could be minimized, hidden behind other windows, or visible, and when the shortcut key is pressed, it will...

So i have a userform in excel that I've added a button to that minimizes the form for me. On workbook_open I have a code to make the application hidden "application.visible = false" and everything is great however once i minimize my form and then click it from the bottom to open it back up, the...