minimize

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

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

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

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

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

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

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

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

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

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

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