Sheet protection > Protect from editing, leaving it open for vba?

[IndigoDragon]

Hi everyone,

[Excel]
Is there a way to protect a sheet from being edited directly by a user, even hiding it, but still being able to edit the data in the sheet through vba?

ThanX for your replies!

 

[Bogiemon]

You can set the Visible property to 2 (Very Hidden), this way the user can not unhide the sheet.

You can always protect the sheet with a password and unprotect the sheet in your VBA before you do any amendments to it.

 

[xlbo]

Have a look at the UserInterfaceOnly property of the Protection method - this allows exactly that - to the user, it appears protected but code can run on the sheet as if it were not

Needs to be set every time the workbook is opened however as it resets when the workbook is closed - it therefore needs to be coded in the Workbook_Open event

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[IndigoDragon]

Hey XLBO!

That was exactly what I was looking for, thanx!

 

[xlbo]

no probs !

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question