restrict adding sheets

Posted by: hpadmasola1 on 8 September 2017, 2:05 pm EST

  • Posted 8 September 2017, 2:05 pm EST

    I have two sheets on my spread loaded with data. I want to restrict the users from adding more sheets. how can I remove that option ?


    Thanks in advance


    Harish

  • Replied 8 September 2017, 2:05 pm EST

    Harish,

    For the desired behavior, you can turn the new sheet tab off. This will disable users from adding their own worksheets.

    FpSpread1.TabStripInsertTab = False 

    Hope this helps. Thanks

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels