Thread: Window Options
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Window Options

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