Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109107

Re: ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly

Show all headers | View raw

Thanks!

I want to make sure: Does it work even if the sheet always stays on Manual Calc and all cells are protected?

On Monday, July 25, 2016 at 11:21:57 AM UTC-7, GS wrote:
> This is working for me...
> 
> 
> Private Sub Worksheet_Change(ByVal Target As Range)
>   If Not Intersect([AJ6:DT105], Target) Is Nothing Then
>     Range("last4SessionsCalculations").Calculate
>     Range("rolesSuggested").Calculate
>   End If
> End Sub
> 
> -- 
> Garry
> 
> Free usenet access at http://www.eternal-september.org
> Classic VB Users Regroup!
>   comp.lang.basic.visual.misc
>   microsoft.public.vb.general.discussion
> 
> ---
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly David Godinger <daveg7@gmail.com> - 2016-07-25 10:45 -0700
  Re: ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly GS <gs@v.invalid> - 2016-07-25 14:21 -0400
    Re: ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly David Godinger <daveg7@gmail.com> - 2016-07-25 19:07 -0700
      Re: ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly GS <gs@v.invalid> - 2016-07-25 22:44 -0400
  Re: ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly ltomama0945 <ltomama0945@gmail.com> - 2016-07-27 02:50 +0100
  Re: ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly edelkochen <edelkochen@gmail.com> - 2016-07-27 04:07 +0100

csiph-web