Guest Blars Posted January 4, 2019 Share Posted January 4, 2019 How can I override the "not editable" cells in a worksheet to be editable? I dont want the fields to be tied to an object any longer. I want them to be "dumb." Thanks! Quote Link to comment
Pat Stanford Posted January 4, 2019 Share Posted January 4, 2019 Not possible in a database row. Only possible in worksheet rows. You can copy/paste from the database into a worksheet. Or if you still need the database, but just want to be able to "manually" enter some data you can use a custom Record.Field format to allow data to be changed in the database rows. But it will still be linked to the object. See the following thread for more information. Quote Link to comment
NickMac Posted May 4, 2020 Share Posted May 4, 2020 I also have this problem. I have a worksheet set up to generate a window schedule. Some cells derive information from the window object, but other cells are editable to input additional information. This has worked fine up until now, but suddenly these cells cannot be edited. I used to be able to double-click into these and input data, but now the text is just greyed out and I cannot edit it. ?? Help? Quote Link to comment
Boh Posted May 4, 2020 Share Posted May 4, 2020 Have you recalculated the worksheet? Quote Link to comment
NickMac Posted May 4, 2020 Share Posted May 4, 2020 I'll try that next time. I was advised by our vw reseller tech support to go into the worksheet, edit the criteria of the cell that defines criteria of the worksheet, then just hit ok. This (I guess it recalculated the criteria) allowed me to edit all the available cells.. who knew? Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.