screenupdate display

  1. M

    VBA create form and save file of specific sheets

    I have a VBA code to create staff form. there are two problems need to be solved. Q1 : after creating sheets, the sheets will be saved as file. I only want to save the sheet(7) to sheets.count ? (i.e. sheet (1) to sheet (6) is not required to save file. but below code will save all sheets...
  2. M

    Auto update image VBA

    Hi all, It is probably simple, but could not figure it out. The macro that i use is for getting product images for quotations. The only problem is that i want it to autoupdate. (Now i have to click button to see images on sheet, before sending quote). Sub AfbeeldingenOfferte() picname1 =...
  3. R

    Userform modeless and screenupdate = false in excel 2013

    Hello, In Excel 2013, it was not possible to scroll in a worksheet after using a userform. With some help from this forum I found the option userform modeless. This fixed the scrolling problem but creates a new problem: screenupdate = false doesn't work any more. Can anybody help how to fix...
  4. J

    Screenupdating Still Updates...

    I have used the following code numerous times and it works as advertised (Excel doesn't update until enabled): Application.ScreenUpdating = False Application.Calculation = xlManual Application.DisplayAlerts = False However, I've run into a situation where the screen still updates even after...
  5. K

    Screen output while ScreenUpdate = False

    I have a rather long macro which copies, pastes & sorts across some 60 or more sheets (the actual number can vary). With the screen visible, I finish up with a jumbled mess for a few minutes - sometimes much longer. With ScreenUpdate set to False, the user has no indication of progress and...

Some videos you may like

This Week's Hot Topics

Top