Why will Excel sometimes only allow cut and paste if you first enter design mode.
design mode to be able to cut and paste
-
-
-
I have not encountered such a problem, can you elaborate a bit more?
-
Dave - I have a workbook that I have been developing for months and I keep on finding that I get to a stage with this workbook that for me to be able to cut and paste I first have to enter design mode otherwise the functions are not available. There is a lot of vba involved and it may be something dumb like turning off screenupdating and having an error stop the code so screenupdating may just need turning on......
I just thought that before re-inventing the wheel, someone out there may have seen this before.
It would be great to be able to push an application.status button.
-
Try creating a button that switches ScreenUpdating back on, and use it next time the error occurs. Then you will know if you guessed right
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!