window

  1. S

    Trouble pasting VBA code, scrolling down post, typing

    Hi, Brand new here, and I'm having a little trouble with the site. First problem I ran into is trying to paste VBA code onto a post. I click the "paste as plain text" button, a window pops up, I hit ctrl+v, submit it, and nothing happens. Sometimes the window won't even pop up. I've also...
  2. C

    Excel opens new files all in same window

    My excel windows all open in the same window. If I open a new file, it opens in that window. I have 2 monitors, I want 1 spreadsheet on 1 monitor and another spreadsheet on the 2nd monitor. If I click View, "New Window" it does not like that excel program, so I cannot drag it to another monitor...
  3. P

    Update UDF for Win 10

    Hi folks I have a simple UDF just to compare text files and highlight any lines between the two that do not match, it simply runs the basic DOS file compare function but just simplifies the usage. Just had my work pc upgraded to Win 10 (Yep... just), and now find that this doesn't work any more...
  4. A

    Close workbook "excel window" on open

    Hey what I need is simple buy I am not able to perform it I am using the following Vba code: Private Sub Workbook_Open() Workbooks("close opened.xlsm").Close End Sub I need the window which contain the workbook to be closed totally not only close it at the same window I have made .bat...
  5. C

    Use VBA to run/terminate Shell command and save file

    Greetings! I have a shell command that uses curl to capture live audio output from a port on our call server. Sub RecordAudio() Call Shell("cmd.exe /S /K" & "curl 92.68.0.10:8888 > i:\voicetemp\voice.wav", vbMinimizedFocus) End Sub What I would like to know is; 1) how can I stop the...
  6. M

    VBA window sometimes opens very small

    When I open my Macro-Enabled workbook and then click Developer -> Visual Basic, the VBA window sometimes opens extremely small. It doesn't always do it, but I'd say around every 5th or 6th time I open the VBA window (when Excel has just been launched) it will do this. Anyone ever have this...
  7. mikecox39

    Alt-F11 does nothing, security set to allow all.

    Alt-F11 toggles the text in the green title bar gray and a tiny shadow appears around the window. Alt-F8. Displays my macros but Edit option only closes the window and the text in the green title bar blinks gray. In the Trust Center/Macro settings I have Enable all.... set. I also have the...
  8. D

    Display code in a special window in MrExcel Forum

    Hi all, :) I know many of you use a specific window when you put the VBA code you use in that forum. I would like to know how you do it . Many thanks for your answer Regards
  9. S

    BeforeClose on a window?

    I have a board display using multiple windows within Excel spread across multiple monitors. During various events windows popup to show other information and when de-activated, the window is closed. This works like a charm until someone closes the window to deactivate it, in which instance the...
  10. JenniferMurphy

    UDF gets executed twice for a single call

    I am working on a UDF that may be more complicated than I can handle. (sigh) The UDF is called just once from a single cell in the only sheet in the only open workbook. I have break point (F9) set at the top of this section of code: . . . Dim iCol As Long Dim RBestI As Variant Dim...
  11. H

    Opening spreadsheets in separate windows

    How can I set Excel to open spreadsheets in separate windows when opening new/previously saved spreadsheets? Currently I have two work laptops, main laptop opens each spreadsheet into its own window. Alternate opens each spreadsheet into one window, main laptop is running Office 2013 alternate...
  12. S

    VIEWABLE, not VISIBLE!

    Hi Guys.... Does anyone know a way to discover which is the rightmost column IN VIEW in a Window showing an Excel Worksheet with column A as its leftmost column? I'm visually impaired, so I use a low resolution, and normally I can see col L with Excel in full screen mode. I'm trying to use...
  13. G

    Sheet not functioning properly

    I have a workbook that is supposed to open a form window and keep the workbook window hidden, which it did for a time. First it issue was after opening and closing once, the next time you open the workbook it would open both windows. Now it does it every time and I dont have the complete...
  14. R

    VBA window issue on Mac.

    Hi All I've been using Excel on Mac for many years and never had this issue till now. It's probably more that I don't understand than an issue. I have always been able to double click on sheets in Excel Objects, they would open in a window with a gray title bar and the option to close, min or...
  15. C

    excel vbscript for command button to retry script

    So my workbook has a lot of script in it and I use "Bundles" of script to perform big functions, one such function that resides in a bundle of scripts reaches to SAP through GUI Scripting and pulls data. It is set to use an active window not with hard coded user and password info so if the user...
  16. Y

    Watch Window - fix column view

    Hello All. if I select a cellor cells to add to the watch window, the columns added are: Book, Sheet, Name,Cell, Value, Formula Because I'm onlyinterested in the value, and as I don't want the watch window to take up a lotof unnecessary space. I reduce the width of the window, and scroll to...
  17. jim may

    Working With A New Window in Excel

    What I've been trying to do might not be possible, but I'll ask anyway... In my File on a Given Worksheet named "Main" - I clicked on View - New Window So Now I have MyFileName.xlsm:1 and also (now, not before) MyFileName.xlsm:2. Originally on my Main Sheet (Now +":1")- I had Sheet1, Sheet2...
  18. Z

    Row checking Macro

    Hello All, I'm currently working on updating a logging system we use at work. Currently the log has 4 Columns. I have revised the log in order to add a macro program to automatize a few items. So here is what we have. Column A has been page set to either have a blank or "C". This being if...
  19. M

    Web query error handling...

    Hi Team, I have the following code that returns data from the web (via Power Query): Application.ScreenUpdating = False If CheckBox1.Value = True Then Sheet3.Range("B4").ListObject.QueryTable.RefreshPeriod = 1 Else...
  20. R

    Scrollbar window in Userform

    Hi there, I have a userform which has a large amount of user inputs on the left hand side. There isn't much room and everything is a bit small and difficult to operate. The right hand side of the userform has some other controls which need to be visible at all times. Is it possible to embed my...

Some videos you may like

This Week's Hot Topics

Top