PDA

View Full Version : Solved: Protecting Custom Properties



tools
01-12-2009, 04:28 AM
Hi all,

Is there a way by which we can protect the Custom Properties that we add in an excel sheet ?

Thanks & Regards

Bob Phillips
01-12-2009, 04:31 AM
Not really. You can always reset them before you need them, but this makes it a bit pointless.

Do you have to use custom properties?

tools
01-12-2009, 04:35 AM
I have template and depending on few properties that have been set I have to function accordingly. So I need those properties to be protected and should not be allowed to be changed by the user.

Bob Phillips
01-12-2009, 04:40 AM
When I ask if you have to use custom properties I mean can you use something else, a hidden worksheet, hidden names for example?

tools
01-12-2009, 04:55 AM
No I cant use hidden sheets .

What are hidden names ??

Bob Phillips
01-12-2009, 05:06 AM
It is an Excel defined name, but you can set the hidden property to true, but only in VBA, that is your user can't unhide it, even if they knew it.

Why can't you use hidden sheets?