Using styles I get it to work. It's a pity though that one can't simply
set isLocked.
Graham
On 19 July 2012 13:35, Johnny Rosenberg gurus.knu...@gmail.com wrote:
2012/7/19 Graham Luffrum grhmlf...@gmail.com:
Hi,
I am trying to write a macro that will, amongst other things, lock a
Hi,
I am trying to write a macro that will, amongst other things, lock a single
cell in a Calc sheet. I can easily test to see if the cell is locked,
using CellProtection.IsLocked, but I don't see how to change the value.
Any ideas?
Graham
--
For unsubscribe instructions e-mail to:
On 19/07/12 11:19, Graham Luffrum wrote:
Hi,
I am trying to write a macro that will, amongst other things, lock a single
cell in a Calc sheet. I can easily test to see if the cell is locked,
using CellProtection.IsLocked, but I don't see how to change the value.
Any ideas?
Graham
Way
2012/7/19 Graham Luffrum grhmlf...@gmail.com:
Hi,
I am trying to write a macro that will, amongst other things, lock a single
cell in a Calc sheet. I can easily test to see if the cell is locked,
using CellProtection.IsLocked, but I don't see how to change the value.
Any ideas?
Graham
I