design mode to be able to cut and paste

Dovrox · Sep 16th 2004

Why will Excel sometimes only allow cut and paste if you first enter design mode.

Dave Hawley · Sep 16th 2004

I have not encountered such a problem, can you elaborate a bit more?

Dovrox · Sep 16th 2004

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.

**royUK** · Sep 16th 2004

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

design mode to be able to cut and paste

Participate now!

Share