![]() |
#3
|
||||
|
||||
![]()
It is protected, yes. It must, however, remain protected in order to prevent certain locked cells from being modified. It is a protected worksheet with tracked changes enabled. I've made a macro that activates whenever a change is made to the worksheet. This is why undo is greyed out. When you use the Worksheet_Change function, VBA clears the undo stack. My solution to this is to save the worksheet to a hidden one before each change is made, and then restore it if the user wishes to undo an action. I just need some help on how to do this programatically.
|
Tags |
hidden, undo, worksheet |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
custom icon, undo/redo for macro, permanent macro | Rapier | Excel | 0 | 08-05-2013 06:30 AM |
![]() |
delete123 | PowerPoint | 2 | 04-10-2013 05:38 AM |
![]() |
ReviTULize | Word VBA | 4 | 02-01-2013 01:46 PM |
![]() |
jeffk | Word | 5 | 12-11-2012 10:25 AM |
![]() |
virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |