Oct 28 2021 02:46 AM
I created a MS Excel file about playing Tic-Tac-Toe. I can make it to show the images dynamically based on user input.
However, I found it use too many formula (9 formula, each cell it using its own formula). I would like to use a single formula for the cells (9 cells). The situation I am now encountering is that the formula on Shape does not "determine" which cell is containing the shape.
Is it possible to use a single formula for the 9 cells (shapes)?
Also, is it possible to make the shapes un-selectable under worksheet protection?
I do not want VBA approach. Thank you.
The excel version I am using is Excel 2019.
Oct 29 2021 03:01 PM
@Willy Lau wrote:
Is it possible to use a single formula for the 9 cells (shapes)?
I don't think so. What appears in a given cell is dependent (when using formulas) on the formula that is IN that cell. So nine cells need nine formulas (at a minimum).
Also, is it possible to make the shapes un-selectable under worksheet protection?
I think so, but you've hidden and protected everything, so it's hard to know how you're achieving what you're achieving even now. When you come asking for help here, you'd help us help you if you both unprotected and made visible the various functions/formulas/whatever.
I do not want VBA approach.
I'm with you on that general preference, but there are times when VBA works better than straight formulas/functions.
Anyway, why don't you reveal more of the inner workings for what you have here so those who know BOTH functions AND VBA can offer informed suggestions.
Nov 07 2021 09:19 AM
Thank you very much for your reply.
It is sad that I cannot use a single formula for the 9 cells. I thought I might use a formula with relative address for the 9 cells. I tried in many way, but I cannot make it happen.
Sorry for the hidden and protected cells.
Thank you for the suggestion to me to conside about VBA. I understand VBA might be a better way to it. However, if VBA is used, there is no way to use formula (I think VBA can create shapes with a specified image/move the focus to cells when a shape is selected/after user input, just clear the input but create a desired shape on the cell, etc. In addition, the target users do not want to enable VBA. Hence, VBA will not be used.
Currently, the way how is work is as below:
Thank you very much.
Dec 26 2021 10:07 AM