Locking cells

[halcyoneus]

Well, I want to do more then just lock cells....

I have a little program whipped up in ecxel and I don't want anyone to be able to modify any cells except cells A1 or A2. I've been able to do this using the Validation function in Excel, but want to go 1 step further. I don't even want anyone to be able to select any other cells. If they do, I want the selection to automatically select either A1 or A2.

Anyone have any ideas to help?

~Hal

 

[RAM]

Gibbs,

Thanks for the update.

I haven't worked much with other versions than 2003 and 97, and 97 was too long ago to remember the protection properties.

Hal,

I'm curious what version of Excel you're using.

RAM

 

[halcyoneus]

I've got Office 2000 Premium.

~Hal

 

[XLGibbs]

Well, I work with Microsoft XP, Broken Edition. Complete with the Errors.DLL

So I am used to all the "fun" things those geniuses at Microsoft come up with.

 

[RAM]

I got Office 2003 and we're all having fun, haven't we?

RAM

 

[RAM]

Hal,

Hold down Ctrl and select the two cells you want the user to be able to select. Format - Cells and unselect Locked in the protection tab - OK. Then Tools - Protection and select Protect Sheet. Unselect Select locked cells,
(make sure only Select unlocked cells is marked) - OK.

Edit: The second post in this topic also tells you how to dock the protection toolbar in the menu. It will speed things up when you're working with protections.

Hal,

I just realized I forgot to add the link to the topic I mentioned in above quote. Here it is:

http://www.mrexcel.com/board2/viewtopic.php?t=183754&highlight=protection

HTH

RAM

 

[halcyoneus]

Arrrggg,
When I close and save the spreadsheet and re-open it, the "Enable Selection" in the VB window changes back to NoRestrictions when I changed it to UnlockedCells even after I saved before closing. I even added the code EnableSelection = xlUnlockedCells for that specific tab and that doesn't help.

Anyone know what I can do?

~Hal

 

[bandit_1981]

The best way todo this in 2000 is to set the scroll area equal to only those 2 cells.

 

[halcyoneus]

OK, I tried that and it works just as well as the "Enable Selection", but doesn't save when I close & save then re-open.

Maybe I'm just n ot saving the VB window correctly.

~Hal

 

[bandit_1981]

You set the scroll area on the worksheet activate using VBA.

IE on the worksheet active you place code like this

activesheet.scrollarea = "A1:B1"

 

[halcyoneus]

Yup, That's what I did.....

but when I save and close, then re-open...it changes back to the default.

~Hal