I have an excel file that needs to do the following things.,
some cells are required to be validated using the data from other sheet within same workbook, once user finished typing to specific cells.
some cells are need to be auto-enabled or auto-disabled based on the value from other cells
some cells are required to display dynamic images based on what user typed.
So I wrote VBA Macro code to do those tasks.
But because of the security issue and cross platform issue (eg. Macro not working on web), I don’t want to use macro any more.
So may I know if you have any alternative solution for that.