View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Duncan[_5_] Duncan[_5_] is offline
external usenet poster
 
Posts: 290
Default Why Undo commandbutton is Cleared ?

Halim,


As far as I know, you cannot undo anything done via VBA code.

I may be wrong, but I have noticed this and it has never let me undo
anything I have done through code.

is there a specific action you wish to undo as you may be able to
achieve it with your code, like storing the previous settings and then
restoring after your code?

Duncan


wrote:

Hi all,

I have a problem if I use :

'
sub cariorfind()
set findx = activesheet.cells.find(What:="words")
if not findx is nothing then msgbox findx.address
end sub
'

the undo command lists is cleared after the procedure above,
so I can't undo my previous action... :(
anyone please help me to answer it ...!

Thank you very much..
regds,
Halim