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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top