VBA to Cancel Last Action on Protected Sheet!

Hi all,

If possible can someone please help me out with the below.

Basically I have this code whose aim is to cancel the last action which was performed:

Please Login or Register  to view this content.

Now besides this simple code, I tried protecting the sheet and amended it to read:

Please Login or Register  to view this content.

However sometimes it is showing up an error:
'Method 'Undo' of object'_Application failed.'

I think it has something to do depending on what I did as my last action. If I manual input some data, the macro works fine. However if I don't input data it is showing up this error.

If it is not too much to ask, can someone assist me with the above please. Maybe can I include a code which if it finds an error, it does not run the code?

Appreciate a lot your kind help!!!

Thanks

keibri

undo is not available with VBA

if all you want to do is skip the error then try:

Please Login or Register  to view this content.