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


    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.


  • 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