screenupdate display

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

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

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

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

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