Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MoveAfterReturn fails because sheet is protected
I am using Windows XP with Office 2003.
I have the following programs in a sheet module: Private Sub Worksheet_Activate() Application.MoveAfterReturn = False End Sub Private Sub Worksheet_Deactivate() Application.MoveAfterReturn = True End Sub But, when the sheet is activated, the cell pointer still moves after enter. This failure only occurs if the sheet is protected. I want it to work when the sheet is protected. How can I get this to work? Thanks in advance for your assistance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code fails when sheet is protected | Excel Discussion (Misc queries) | |||
Macro fails when worksheet protected | Excel Discussion (Misc queries) | |||
MoveAfterReturn command fails in Worksheet module | Excel Programming | |||
MoveAfterReturn is tricking me. | Excel Programming | |||
VBa, Password protected sheet fails to get unprotected with the same password | Excel Programming |