Cell Protection

[lukemedway]

How can i lock a cell without the complication of adding user permissions as this wont be avaliable when i take my assignment into college?

 

[Nimrod]

Locking and Hiding cells is done through : right click on cell... format... protection tab.
By default all cells have lock checked. Uncheck if you do not want protected.

Now go to toolbar and select ... tools.. protection ... protect sheet

 

[lukemedway]

Ah yes but there are certain cells that i want to remain active and editable! By protecting the worksheet, it means they cannot edit anything!

I only want to protect certain cells

 

[James]

Re-Read Nimrods post!

James

 

[lukemedway]

Ah feck, im not with it today i really aint!

*puts his head in a bucket of water and holds for 10 mins*

 

[lukemedway]

Ok, new problem because the cells are protected my macro button doesnt work anymore!!! ARGH!!! (i hate spreadsheets)

The macro sorts the data in the cells but when i try to run it by clicking the button, i get a run-time error doh!!!!

 

[James]

Private Sub CommandButton1_Click()
With Selection
Sheets("YOUR SHEET NAME HERE").Unprotect password:="YOUR PASSWORD"
YOUR CODE HERE
End With
Sheets("YOUR SHEET NAME HERE").Protect
password:="YOUR PASSWORD"
End Sub

James

_________________
This message was edited by James on 2002-05-08 11:30

 

[lukemedway]

hmmm... now it says that it doesnt support this method and highlights this pices of code

Sheets("100m").UnProtect_password = "whatever"
This message was edited by lukemedway on 2002-05-08 11:30

 

[Nimrod]

I usually don't bother with a password when protecting the sheets. After all we're just trying to prevent any changes by mistake.
Forget passwords for this stuff it's not worth the bother.

Other then that I totally agree with James suggestion...great solution
_________________

NOTE: Testing performed on Win2K utilizing Office 2000. Solutions may not work on other versions.
This message was edited by Nimrod on 2002-05-08 11:30

 

[lukemedway]

So if the code is set out like that

Sheets("100m").UnProtect_password = "whatever"

do i just remove the password bit, so i looks like this?

Sheet(100m).Unprotect
This message was edited by lukemedway on 2002-05-08 11:38