Remove tabs

[#1]

Hello QV experts,

Is it possible to remove tabs from script editor using a macro?

I have multiple tabs (not sheets) in the script editor.  I dont require all of them after first reload. I want to remove few of them but not manually. I would like to do this using a macro call subs or function call?? Please help me if this is  possible to achive

Thanks & Regards

Padmasali

[#2]

ActiveDocument.RemoveSheet 1 should work.

Regards,

Kiran.

[#3]

ActiveDocument.RemoveSheetByID "SH01" is more appropiate.

Regards,

Kiran.

[#4]

Hi Padmasali,

If I am not wrong, you might beon of thse two kind of situation.

1. You have only one tab,you don't user to see it as a tab:

Go to   Settings>>Document Properties(Ctrl+Alt+D)

On General Tab:

Select Hide Tab row

2. You have multiple tabs, but you do not want to see the tabs on the top:

Create Mutile Buttons for the tabs.Go to Properties of the Button.

Properties>> Action. Click the Add button

Choose Action type as "Lay Out" and Action as "Activate Sheet"

Now fill the Sheet Id for other tabs.

Hope it might help.

[#5]

Hi Panmasali

Remove tabs you just click on Tab   then click Remove is OK

Bgds

ENN

[#6]

Hi Padmasali,

I misunderstood your requirement. There are two ways I usually do:

1. Add IF IsPartialReload flag and segment the script to full reload vs. updates.

2. You can run set a variable to 1/0 based on your parameter an segment your script. This way when you run a second reload only partial script is reload

Hope this helps.

Regards,

Kiran.