Excel Macro Replacement

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.

Thanks.