PDA

View Full Version : Solved: Excel 2003/07 - Why does using Application.ScreenUpdating not hiding sheet select



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

frank_m
11-04-2010, 01:48 AM
Never mind. The code I posted here does work. I had a typo in the code that I was actually using. :bug: :rotlaugh: