Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2006

Tip: Looking for answers? Try searching our database.

How do I diable Show Tabs under Option Menu

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
funkymonkUK - 19 May 2006 10:13 GMT
Hi

I got a workbook which I would like to disable the option of showing
the Tabs button as well as some other option found under the option
menu so that an advanced user can not enable the show tabs option. I
tried Protected workbook (No luck)  Tried protecting sheet (No Luck)
there must be a way.

Many thanks

Signature

funkymonkUK

Ivan Raiminius - 19 May 2006 10:22 GMT
Hi,

try this:

activewindow.TabRatio=0

regards,
Ivan
funkymonkUK - 19 May 2006 10:33 GMT
is there away but with without code as I do not want macro in thi
workboo
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.