I am experiencing some activity in a couple of files now where Data Validation is in use.
The files that are experiencing this have the following applied to the visible screen and all other UI screen sin the files
In the file I am currently experiencing the issue I have a sheet named 'Launch Page' and a 'Product Selection' Page.
When using the data validation cell in 'Product Selection' page, some of the 'Launch Page' cells bleed into the 'Selection Page'
Below is an image of the Launch Page
This is an image of the Product sheet prior to any interaction with the sheet
And below is an image of the Product page as soon as I start to interact with the sheet
Previously I have used
which deals with the problem, but ideally I don't want to have the problem.
TIA
The files that are experiencing this have the following applied to the visible screen and all other UI screen sin the files
Code:
ActiveWindow.Zoom = True
Application.Goto Range("A1"), True
ActiveSheet.Protect Password:=strPassword
Application.DisplayFullScreen = True
Application.DisplayFormulaBar = False
ActiveWindow.DisplayHeadings = False
ActiveWindow.DisplayWorkbookTabs = False
In the file I am currently experiencing the issue I have a sheet named 'Launch Page' and a 'Product Selection' Page.
When using the data validation cell in 'Product Selection' page, some of the 'Launch Page' cells bleed into the 'Selection Page'
Below is an image of the Launch Page

This is an image of the Product sheet prior to any interaction with the sheet

And below is an image of the Product page as soon as I start to interact with the sheet

Previously I have used
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
Application.ScreenUpdating = True
End Sub
TIA