Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 06-04-2014, 05:00 AM
jpb103's Avatar
jpb103 jpb103 is offline Enabling the undo function in a macro enabled workbook Windows 7 64bit Enabling the undo function in a macro enabled workbook Office 2007
Advanced Beginner
Enabling the undo function in a macro enabled workbook
 
Join Date: May 2014
Location: Thunder Bay, Ontario
Posts: 58
jpb103 is on a distinguished road
Default

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.
Reply With Quote
 

Tags
hidden, undo, worksheet



Similar Threads
Thread Thread Starter Forum Replies Last Post
custom icon, undo/redo for macro, permanent macro Rapier Excel 0 08-05-2013 06:30 AM
Enabling the undo function in a macro enabled workbook Saving as ( PowerPoint Macro-Enabled Slide Show )?? delete123 PowerPoint 2 04-10-2013 05:38 AM
Enabling the undo function in a macro enabled workbook Macro-enabled Template ReviTULize Word VBA 4 02-01-2013 01:46 PM
Enabling the undo function in a macro enabled workbook strangeness in undo function? jeffk Word 5 12-11-2012 10:25 AM
Enabling the undo function in a macro enabled workbook macro to transfer data from one workbook to another workbook virsojour Excel Programming 5 02-01-2011 08:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft