VBE/Enabling Worksheet Tabs (2000)

Topic

New Reply

How do I enable worksheet tabs from VBE? I tried:

Application.CommandBars("Worksheet Tabs").Enabled = True

but it does not seem to work (unless the workbook/sheet has to be unprotected first?).

Thanks,

Reply | Quote

Replies

Actually, the correct syntax is:

“Workbook Tabs” instead of “Worksheet Tabs”

Reply | Quote

If you mean how do you display worksheet tabs try using

ActiveWindow.DisplayWorkbookTabs = True

zeddy

Reply | Quote

That enables the rightclick menu you get when you rightclick the sheet navigation arrows bottom left of the XL window.

The rightclick menu of sheet tabs is called “Ply”.

Find these (and more) in my xlmenufundict.zip at:

http://www.bmsltd.ie/mvp%5B/url%5D

Edited Mar 13th 2004 to update link

Reply | Quote