View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin T. Ryan Kevin T. Ryan is offline
external usenet poster
 
Posts: 6
Default Undo functionality w/ VBA?

Hi all -

I was wondering if anyone knew of a way to save the state of an excel
workbook so that users could Ctrl-Z (i.e. undo) changes made by a VBA
procedure or macro? For example, if my macro simply bold-faced a
particular cell, Ctrl-Z would revert the formatting to whatever it was
before? Any thoughts would be appreciated. TIA,

Kevin