Posted to microsoft.public.excel.programming

kkknie[_116_] kkknie[_116_] is offline

external usenet poster

Posts: 1

Disable Worksheet Tab Menu

Found by recording a macro...

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWindow.DisplayWorkbookTabs = True
End Sub

Private Sub Workbook_Open()
ActiveWindow.DisplayWorkbookTabs = False
End Sub

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA to disable "Delete...." on shortcut menu of worksheet tab?	Mary Kathryn	Excel Discussion (Misc queries)	3	March 3rd 06 05:54 PM
How disable menu command	Armangelo	Excel Discussion (Misc queries)	0	February 1st 06 10:00 AM
Disable menu selection	andy	Excel Discussion (Misc queries)	3	December 10th 04 10:46 PM
Disable Worksheet Tab Menu	Ron de Bruin	Excel Programming	1	June 1st 04 05:59 PM
Disable Menu Item	OCI	Excel Programming	0	May 19th 04 05:41 PM

All times are GMT +1. The time now is 05:07 PM.

About Us

"It's about Microsoft Excel"