Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to undo changes made to Excel sheet programatically

Hi,
I have made a Excel VBA based application where in I have some feature
where I insert rows and assign formulas for the new rows by means o
VB. But, the problem is that once the new rows and formulas ar
inserted, I am not able to undo the changes.

Can anyone please tell me if there is a way to undo the changes mad
either directly or by means of a program which I can assign on a butto
click.

Please help!!!!!!!!

Thanks,
Samee

--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,624
Default How to undo changes made to Excel sheet programatically

Take a look he

http://j-walk.com/ss/excel/tips/tip23.htm

In article ,
sameerce wrote:

Hi,
I have made a Excel VBA based application where in I have some features
where I insert rows and assign formulas for the new rows by means of
VB. But, the problem is that once the new rows and formulas are
inserted, I am not able to undo the changes.

Can anyone please tell me if there is a way to undo the changes made
either directly or by means of a program which I can assign on a button
click.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to track changes made to a excel sheet using VisualBasic Daffo Excel Discussion (Misc queries) 10 August 31st 06 06:10 AM
Can I undo changes I made days ago in my Excel spreadsheet? hotslap Excel Worksheet Functions 1 August 25th 06 02:01 AM
How do I undo write protected to excel sheet send to floppy disk ron Excel Discussion (Misc queries) 1 March 26th 06 08:55 PM
My excel toolbar is grayed out and I can't undo it. Sheet is not. Betsy New Users to Excel 1 December 9th 04 09:23 PM
Programatically Breaking Links of Copied Chart Sheet Matthew Wieder Excel Programming 1 July 18th 03 04:58 AM


All times are GMT +1. The time now is 03:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"