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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MoveAfterReturn fails because sheet is protected
The code works fine on my machine... You mention that the code is in a sheet
module. Just to clarify... It is in a sheet? Not in a module. Try putting break points on the procedures or put a message box in the procedure just to make sure the events are firing. Speaking of event firing... in your code anywhere do you toggle the Application.enableevents = false without setting it back. Application.enableevents = true If your events are off you are hooped and will have to reset them. HTH "quartz" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MoveAfterReturn fails because sheet is protected
Jim,
Thanks for your reply. Events are not disabled anywhere in my code. The only cells that are unlocked are those on a single row. It is strange that this works if the sheet is not protected... "Jim Thomlinson" wrote: The code works fine on my machine... You mention that the code is in a sheet module. Just to clarify... It is in a sheet? Not in a module. Try putting break points on the procedures or put a message box in the procedure just to make sure the events are firing. Speaking of event firing... in your code anywhere do you toggle the Application.enableevents = false without setting it back. Application.enableevents = true If your events are off you are hooped and will have to reset them. HTH "quartz" wrote: 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. |
Reply |
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 |