
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ActiveDocument.RemoveSheet 1 should work.
Regards,
Kiran.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ActiveDocument.RemoveSheetByID "SH01" is more appropiate.
Regards,
Kiran.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Panmasali
Remove tabs you just click on Tab then click Remove is OK
Bgds
ENN

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
