able to insert/delete rows in locked spread

Posted by: ginacresse on 8 September 2017, 1:02 pm EST

  • Posted 8 September 2017, 1:02 pm EST

    Hi,


    I'm using this code to lock a spread control on my form:


    Case "FpSpread"


    Ctrl.Enabled = True 'rather than disable, just lock the spread so it can be scrolled but not changed



    With Ctrl



    With .ActiveSheet



    .DefaultStyle.Locked() = True


    End With


    End With


    Case Else...


    But even though the spread is locked, I'm still able to Insert and Delete rows.  Am I not locking the spread properly?  I don't want the user to be able to do anything but look at the spread.


    Thanks.

  • Replied 8 September 2017, 1:02 pm EST

    Locking the spread only prevents the user from entering edit mode in the sheet to enter data.  But you must be providing them a way to add or delete rows since there is nothing built in the spread to do this.  I would suggest disabling whatever mechanism you have set up for them to do this.
Need extra support?

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

Learn More

Forum Channels