window

  1. T

    Macro to open a sheet in a new window

    Hi Everyone, Hope you can help I want a macro that can open a sheet in a new window. Idealy it would do this. When macro is run open Sheet"PDF Views" in new window and if possible? place new window in middle of screen taking up about 75% of the screen make that screen not show any tabs or...
  2. J

    New Window with VBA (Dual Monitor)?

    Hi, Is it possible with VBA to open a new window (specific worksheet) maximized on to the 2nd monitor with no gridlines?
  3. E

    "Saving" Notification/Status window not closing after VBA Save

    Though currently on Office 365 I have experienced this issue in earlier versions as well. I am using the ActiveWorkbook.SaveAs command to save a new workbook. The save is successful; however the Saving status window does not close. In order to continue processing I must select Cancel...
  4. D

    Close Active window triggers before close event

    I have an excel workbook with 2 views open (View/New Window). When I close the second window (the workbook remains open) it triggers the before close event. Is there anyway of closing the second window with triggering the before close event? I only want the before close event to trigger whe the...
  5. L

    window menu in old excel version

    Hi I am watching the video below and in minute 2:00 he went to Window tab in the menu to find out which excel files are opened. I am using office 365, where I can find that option? Thank you very much. https://www.youtube.com/watch?v=-foPogO3QNE
  6. S

    [VBA] Make AppActivate('d) window maximised

    Hello, I have this code: Sub OpenBrowserLink(link) Dim sh As Object, oWin As Object, IE As Object Set sh = CreateObject("Shell.Application") 'Find an IE Window For Each oWin In sh.Windows If TypeName(oWin.Document) = "HTMLDocument" Then Set IE =...
  7. S

    Highlight Row VBA Toggle command

    Hi, Is it possible to create code to highlight the row of the selected cell? I use two screens so even if I select the whole row when I go to my second display excel doesnt show the highlighted row when I select a different window. I was hoping it was also possible to have a macro that...
  8. E

    Pop up window

    I am making a userform in excel using VBA. I want whenver a textbox1 is left blank after clicking a save button a pop up window is trigerred saying "the textboox1 cannot be left blank" I know how to do this Function ValidateForm() As Boolean ValidateForm = True If Trim(a1.Value) =...
  9. S

    Macros not available in Developer-->Macros tab

    Greetings, I got back on my computer after stepping away and my macros are no longer showing up in the Developer-->Macros window. What could have happened? I visited the options-->trust center-->macro settings but without getting the macros back to visible. Also, clicked on all the files...
  10. S

    VBA - Any way to cycle between excel window and browser window?

    Hi guys. I need to display one of my excel file on a big screen, but also need to show some data from our internal website. (In the website format, so no. Data connection is not an option) I tried messing with the Set objShell = CreateObject("Shell.Application"), but I could only find method...
  11. G

    Crash When Use SetWindowLongPtrA

    When Hook The Window Class #32770 Through Form , It Does Work Fine But When SubClass This Window Inside CBTProc , System Crash And Hang Up , What s Wrong ? Because Of Not Define Handle Window MayBe Happens Crashing ? In Access Application When Open Form And Hook Window Class #32770 , Again...
  12. V

    Want to break VBA code my workbook

    Hi BoardMembers, I know that to braek the vba code question is not valid here.. But what happens we have one workbook which contains vba code. This file works perfectly in Windows 7 but as we are updated with new OS Win 10. It giving us error. Hence trying to open the vba code, so we can...
  13. T

    Macro to choose file and add name to a cell

    Hi Everyone, I would like a macro that when run brings up the folder window like the save as window and asks me to select which AMF file i want to use? I can then select a file from my computer and the name i selected get input into cell G10 Please help if you can Thanks Tony
  14. M

    Trying to get the placement of Excel window on screen on Mac

    I ran across some code on another site that is supposed to get the placement of the Excel application window on the screen of a Mac. The code can be found here: http://www.vbaexpress.com/kb/getarticle.php?kb_id=452#instr It works on Excel 2011, but not on Excel 2019. The string variable...
  15. Y

    VBA F1 Help function gives SSL Libraries error

    Hi All, First post as pretty competant on excel (for my needs) and manage to fnd answers to most things online or trial and error. However I have decided to move into the light and try my hand at VBA :eek2::eek2: and seem to have hit a snag early on with the Help function which I am likely to...
  16. D

    How to Click 'Yes' to Downloading a File

    Hi, I am requesting a file to be downloaded from a website (using Internet Explorer). I get a pop up that asks "Do you want to open or save XXXXX.xls from webpage". Is it possible to use VB to select 'Open' on this window? When I right click over this window (the above question) I do not get...
  17. R

    VBA error handling problem

    Hi, I’m having a problem with the following tract of VBA. It is intended that it should loop round until a window with a particular title (as held in string wtit) is detected. It works ok if the said window already exists before running the code, but it fails on the SECOND time round the loop...
  18. M

    Create New Excel Window - size and position are TOTALY WRONG!

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

    wild window appears

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

    Open native (not Sheet.PrintPreview) print preview window for non-active sheet?

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

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top