View Single Post
 
Old February 22nd, 2005, 04:29 AM
vemaju vemaju is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: , , Finland.
Posts: 168
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi

You must unprotect your sheet first then change cell and then
protect your sheet again

Sub Code()
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, _ Scenarios:=True
'*** Do some changes here
ActiveSheet.Unprotect
End Sub