Hi guys,
can anyone help with this problem.
I have this bit of code to zoom when a cell is selected.
But the problem is that is stops any ability to be able to undo actions from that particular sheet.
Heres the code..hopefully its just a bit of tweaking.
Thanks in advance
Neil
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$A$4" Then
ActiveWindow.Zoom = 120
Else
ActiveWindow.Zoom = 56
End If
End Sub
Hi NeilIE,
I wish it was just a little tweak. Read http://www.jkp-ads.com/Articles/UndoWithVBA00.asp
If you look at the conclusion on the above page it points to code that will Undo.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks