window

I'm working on a small project in Excel (Office 365) where I'm starting to lose my mind, since code is behaving crazy! :banghead: The idea is to open two windows of same Excel workbook at the same time, side-by-side, with specific window dimensions. I prepared an example of new workbook...

Hello everyone, I am facing a problem I never had so far while using vba : a specific lign of code bloc the programm and make a window appear but it is supposedly not supposed to do so. The window isn't an Excel control or anything, just a normal file directory's window asking me to select a...

Hello. I'm trying open "native" print preview window (the same window that opens when clicked print button in toolbar) for a specific sheet. The only command I know that can do this is Application.CommandBars.ExecuteMso "PrintPreviewAndPrint" But I'm having problem open it for a specific sheet...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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