frank_m
11-04-2010, 01:37 AM
Is there something I can do to the code below to make it do as I want?
When I first tried it I thought that it successfully hid the selection of the Log sheet, running some code, then selecting back to the Data sheet.
Now when I tried it again later I can see the selection's occurring.
Application.ScreenUpdating = False
Worksheets("Log").Select
ActiveSheet.Unprotect
ActiveSheet.TextBoxes.Delete
ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:=True, userinterfaceonly:=True
Worksheets("Data").Select
Application.ScreenUpdating = True
When I first tried it I thought that it successfully hid the selection of the Log sheet, running some code, then selecting back to the Data sheet.
Now when I tried it again later I can see the selection's occurring.
Application.ScreenUpdating = False
Worksheets("Log").Select
ActiveSheet.Unprotect
ActiveSheet.TextBoxes.Delete
ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:=True, userinterfaceonly:=True
Worksheets("Data").Select
Application.ScreenUpdating = True