Shared Workbooks and activecell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a shared workbook on which I want to perform a VBA routine: On worksheet change, I want to lock the activcell. For some reason, it appears that the activecell property will not work in the shared workbook. Is this true for all shared workbooks? Can anyone suggest a workaround? (I don't want to lock the entire selection - I only want to lock the cell that changed.

Thank you
Gerry Maher
 
ActiveCell operates at Application level i.e. its full designation i
:-
Application.ActiveCell
The Application in this case is Excel.

It refers to the cell that is currently active in the worksheet that i
itself active. Presumably you are using :-
ActiveCell.Locked = True

Presumably you need to be more specific. To lock a cell we use the sam
procedure as changing any other cell format property, something lik
:-

Workbooks("Book1.xls").Worksheets("Sheet1").Range("A1").Locked = Tru
 
I'm guessing that you want to unprotect the worksheet, lock the cell, and
reprotect the worksheet.

If I'm close, then the bad news is you can't change sheet protection in a shared
workbook.

xl2002 and xl2003 offer finer control of what users can do on protected
worksheets--but xl2002 won't let you change the "lockedness" of a cell in a
protected sheet. (don't have xl2003 to check.)
 
Back
Top