Normally I can undo all event. This problem occur after I select copy and
past or past special value. The undo bottom is disabled. How can I fix this
problem?

Hi,

Simply copying and pasting (or paste special) shouldn't clear the undo list
but a macro running would. Have you got some code running in; for example'
the worksheet_change event?

Mike

"Mesak" wrote:

> Normally I can undo all event. This problem occur after I select copy and
> past or past special value. The undo bottom is disabled. How can I fix this
> problem?

Every workbook have this problem.

"Mike H" wrote:

> Hi,
>
> Simply copying and pasting (or paste special) shouldn't clear the undo list
> but a macro running would. Have you got some code running in; for example'
> the worksheet_change event?
>
> Mike
>
> "Mesak" wrote:
>
> > Normally I can undo all event. This problem occur after I select copy and
> > past or past special value. The undo bottom is disabled. How can I fix this
> > problem?

Test it by starting excel in safe mode:

Close excel
windows start button|Run
excel /safe

and test it a bit.

If it works ok, then maybe it's an addin that's running.

The next step will be doing some detective work.

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

Mesak wrote:
>
> Normally I can undo all event. This problem occur after I select copy and
> past or past special value. The undo bottom is disabled. How can I fix this
> problem?

--

Dave Peterson