PDA

View Full Version : Sleeper: A sheet tab


lior03
07-01-2005, 01:57 PM
i down loaded an example by xld regarding sheet tab.
i try to use it on a macro and got into troubles.
how do i restore the sheet tab to i'ts original setting.
thanks
Justinlabenne
07-01-2005, 02:28 PM
Was this from one of xld's kb entries, of from a post? The sheets tab looks ok to me. Am I overlooking something here?
Bob Phillips
07-01-2005, 03:51 PM
i down loaded an example by xld regarding sheet tab.
i try to use it on a macro and got into troubles.
how do i restore the sheet tab to i'ts original setting.
thanks

What exactly is wrong mate. As far as I can see you have removed the code but not the menu items. If so, and you want to remove those, type


Application.CommandBars("Ply").Controls("Hide Sheet(s)").Delete
Application.CommandBars("Ply").Controls("Unhide Sheet(s)...").Delete

in the VBIDE immediate window
lior03
07-01-2005, 11:15 PM
how do i get to VBIDE immediate window.
do you mean cntrl +g
Bob Phillips
07-02-2005, 02:07 AM
how do i get to VBIDE immediate window.
do you mean cntrl +g

Alt-F11 and then Ctrl-G