I needed to suppress notification warnings about protected sheet when user tries to typing/editing or double click on protected cells.
But I also needed to able to select and copy data of protected cells.
I needed to suppress notification warnings about protected sheet when user tries to typing/editing or double click on protected cells.
But I also needed to able to select and copy data of protected cells.
Last edited by abhinavbinkar; 12-18-2018 at 10:50 PM.
Bump!
Please Help.
can you try..
Sub test() Dim ws1 As Worksheet Set ws1 = Worksheets("Sheet1") Application.DisplayAlerts = False ws1.Protect Password:="test123" ws1.EnableSelection = xlNoRestrictions End Sub
This code protecting the sheet but the message about protected sheet still coming when I try to double click or edit locked cells.
hmm not so sure, on my end the prompt is no longer displaying.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks