View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SP[_3_] SP[_3_] is offline
external usenet poster
 
Posts: 7
Default Selection too large

Hi

I'm still making use of an Excel 4 macro...hooray! :)

Well, while the macro is running, a message pops up "Selection too large.
Continue without undo ?" User can click on Yes, and the macro continues
fine.

Is there a command (of Excel 4 macro) that can suppress this prompt ?

I understand that if I'm using VBA, I can use application.alerts=false.
But, again, I'm still on Excel 4. Please help me solve this problem.

Thanks
Steve