Re: $$Excel-Macros$$ Screen Updating

2013-08-14 Thread respuzy
Ok. Tx Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: vba Sender: excel-macros@googlegroups.com Date: Wed, 14 Aug 2013 10:32:51 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Screen Updating This

Re: $$Excel-Macros$$ Screen Updating

2013-08-13 Thread vba
There is too many reference to external files which makes WS unstable. Try to break un wanted reference, this may help. Thanks//Vabs On Tue, Aug 13, 2013 at 10:08 PM, Hilary Lomotey wrote: > PFA > > > On Tue, Aug 13, 2013 at 5:35 PM, Prabhu Pinky wrote: > >> Hi Hilary, >> >> can u share the fi

Re: $$Excel-Macros$$ Screen Updating

2013-08-13 Thread Prabhu Pinky
Hi Hilary, can u share the file..? Thanks & Regards, Prabhu R On 13 August 2013 21:51, Hilary Lomotey wrote: > Hello Experts, > > i have a sheet am working in, when i press enter in the sheet, the screen > sort of updates and flickers, how do i stop this. it is not VBA that i have > to place

RE: $$Excel-Macros$$ Screen updating

2010-10-30 Thread Daniel
Use : At the beginning of the macro : Dim inCalculationMode As Integer inCalculationMode = Application.Calculation Application.Calculation = xlCalculationManual At the end of the macro : Application.Calculation = inCalculationMode Regards. Daniel De : excel-macros@googlegrou