Clicking Button

Posted by: skumars on 8 September 2017, 1:09 pm EST

  • Posted 8 September 2017, 1:09 pm EST

    I have a spread with 7 Columns 7th column is Buttoncelltype. I want other 6 columns to be read only,
    also i want to select entire row. but if i select read only mode i could not click button.
    i used row mode and i put other columns locked true but i need to select the entire row. in row mode one column is not selected(ie. for editing) i dont want that.

    otherwise in row mode , if I clicked a cell i want to select a last column(7th column and the same row). I tried addselection(e.row, 6,1,7) like that in a cell click event. but i doesnt affect that.

    can any one help me Thanks in Advance

  • Replied 8 September 2017, 1:09 pm EST

    skumars -

    Could you post a small project reproducing this.  Using the AddSelection from the CellClick event should be working.
  • Replied 8 September 2017, 1:09 pm EST


    In addition to what Bob stated, you would need to cancel the Click event by setting e.Cancel = True.

Need extra support?

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

Learn More

Forum Channels