formating locked sheets

[minnymoony]

Hi,
I have an excel sheet "sheet1", that has a button witch creates a table on "sheet2". I want to lock the whole file. I also want to put a button on sheet1 to clear sheet2.
Is it possible to lock the file and still create and erase data on a sheet?

Thanks in advance.

 

[pedie]

Try protecting it this way so that it will be protected except for your code.

Example.

[/FONT]
[FONT=Courier New]Sub Protect()[/FONT]
[FONT=Courier New]Sheets("Sheet1").Protect Password:="mypass", userinterfaceonly:=True[/FONT]
[FONT=Courier New]Sheets("Sheet2").Protect Password:="mypass", userinterfaceonly:=True[/FONT]
[FONT=Courier New]End Sub

After running this. trying changing anything manually, it will not allow it....trying running your macro it will run without having you to unprotect & protect again

 

[minnymoony]

Thanks for the reply,

But I don't quite understand how/where I can implement those lines in my code. Do I create a command button ?

Thanks

 

[minnymoony]

Hi,
I think I managed to understand how to use the code given by "pedie" and so far it works great, Thanks.
Now I have another question.
I have a sheet (sheet1, for example) and I want to put a command-button on sheet1 to create a table (table1, for example) on sheet1. The thing is I want to Lock the sheet and leave part of the cells unlocked and the rest of the cells locked. Also I want to be able to clear the table and its contents, using another command-button.

Thanks in advance