Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Remove tabs

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

5 Replies
Not applicable
Author

ActiveDocument.RemoveSheet 1 should work.

Regards,

Kiran.

Not applicable
Author

ActiveDocument.RemoveSheetByID "SH01" is more appropiate.

Regards,

Kiran.

Not applicable
Author

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

Capture.PNG

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.

Not applicable
Author

Hi Panmasali

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

Bgds

ENN

Not applicable
Author

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.