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

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

Re: ActiveCell VBA with Recalulation of Range Under UserInterfaceOnly

Show all headers | View raw

'David Godinger[_2_ Wrote: 
> ;1624089']I’m using UserInterfaceOnly, so that I can run macros
> and still keep my sheet protected. I tried to use ActiveCell to
> calculate only certain ranges, without stopping protection for the rest
> of the worksheet. I need to recalculate only those ranges, but leave the
> rest of the sheet, unchanged, and on manual calculation. I tested
> ActiveCell and made sure that it works for, as example, putting up a
> message box, but I can’t get it do what I want. Here’s the
> VBA: Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As
> Range ' The variable KeyCells contains the cells that will ' cause an
> alert when they are changed. Set KeyCells = Range("AJ6:DT105")
> If Not Application.Intersect(KeyCells, Range(Target.Address)) _ Is
> Nothing Then Range("last4SessionsCalculations").Calculate
> Range("rolesSuggested").Calculate End If End Sub uppppppppppppppppppppppppppppp lên nao ^^




-- 
edelkochen

Back to microsoft.public.excel.programming | Previous | Next — Previous 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