minimize

  1. L

    Open Window in Excel locked

    Why when I go to the open command in excel the window is full sized. I cannot resize it or minimize it. The excel window itself I'm able to resize or minimize, but the minute i click open the window locks - I can't resize or drag it. Any idea why? It's really annoying when I'm trying to...
  2. L

    After Hide/Disable Ribbon - I want to add a custom menu to title bar - Is it possible?

    The Excel Menu Top Left contains option for Move, Size, Minimize, Close Is it possible to add/remove options to that Menu - Such as Remove Minimize - Add Print, Save, Etc? Is it possible to change Color of Title Bar? Thanks
  3. T

    View & Activate Workbook with Shortcut Key

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

    bar below page tabs problem

    I have a problem on a clients computer that runs a complete excel spreadsheet with significant VBA coding. occasionally a bar (large white space ) appears at the bottom of the window below the buttons , ready across to 100%. when this happens functionality of the workbook stops. it can be...
  5. T

    Copying Data from one sheet to another (1000) sheets

    Dear , I've Sheet 1 contains as below, S.No PO Number Invoice No Qty 1 364526 6747 13 2 765437 5674 45 .... ... 1000 73284 76474 765 and i've format of invoice in sheet 2 to sheet 1000. in this format D1 of...
  6. Nayasoch

    Select the same WorkBook in Background when Userform is Maximized

    Hi there I'm using userform for my Daily Routine with minimize button with following code Private Declare Function FindWindowA Lib "user32" _ (ByVal lpClassName As String, ByVal lpWindowName As String) As Long Private Declare Function GetWindowLongA Lib "user32" _ (ByVal hWnd As Long, ByVal...
  7. M

    VBA Keep menus hidden after minimise/restore

    Hi all, I have some code that hides menus etc. amongst other things but when I minimise then restore, the menus are back. code: Private Sub workbook_open() ActiveWindow.WindowState = xlMaximized Sheets("UserView").Visible = True Worksheets("UserView").Activate Application.DisplayFullScreen =...
  8. M

    Minimize Workbook to sys tray (64bit) -

    Hello All, I have a problem with adjust code to Win7 64bit. It's many examples for Win32. I found this example: Option Explicit Declare PtrSafe Function SetForegroundWindow Lib "USER32" (ByVal hWnd As LongPtr) As LongPtr Declare PtrSafe Function Shell_NotifyIcon Lib "shell32.dll" Alias...
  9. K

    Minimize Ribbon

    I want to minimize the ribbon in Excel 2013 with VBA. I do not want to toggle the ribbon, and I do not want to hide everything including "File", "Insert", etc. I have tried several different methods, but none satisfy what I want. This hides everything: Application.ExecuteExcel4Macro...
  10. Dave Punky

    Minimize Userforms

    Hi all, I've been experimenting with minimizing a userform and I've encountered an issue which I know can be resolved, just not sure how to do it myself. Basically I can add the minimize button but when it actually minimizes the window, I can't edit the worksheet I'm on or browse through any...
  11. F

    Minimize form then maximize with excel sheet still hidden

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top