So, I need to prevent a user from switching active sheets or active cells while my macro is running. Is there anyway to do this, something like being able to lock/disable the user interface?
Printable View
So, I need to prevent a user from switching active sheets or active cells while my macro is running. Is there anyway to do this, something like being able to lock/disable the user interface?
Answered my own question... Application.Interactive=False
Took 3 scans of the Application object in the Object Browser to notice that one.
me=not so observant some times =)