I want to set my window options permanent. For example, no gridlines,
no sheet tabs etc…. But some clients know Excel well enough that they
would go to tools/options and change it. So is there anyway I could
use password to protect the setting of the window options?
Thanks

Why not put the code to set as you wish in the Workbook _Open event. That
way, even if they change them, next time round, they will be as you wish
again.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"NetComm888" wrote in message
om...
I want to set my window options permanent. For example, no gridlines,
no sheet tabs etc.. But some clients know Excel well enough that they
would go to tools/options and change it. So is there anyway I could
use password to protect the setting of the window options?
Thanks

Thanks Bob.
yeah, I could do that. Actually that is my last choice. But I'm
wondering if technically possible that I could forbid the client from
changing the window options. It may not doable at all.