I am trying to get my sheet to automatically run a macro, when a user
inputs the character "Y".

It's reasonably straightforward to tie a macro in with a button press
but I am not sure if it's as easy to do with a specific cell entry.

I'm sure there should be a way to do this. Ideas?