Window Options

  • Thread starter Thread starter NetComm888
  • Start date Start date
N

NetComm888

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)
 
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.
 
Back
Top