Hello,
I have used this code to protect sheets and i have made it not to select locked cells but when this code runs i can still select the locked cells,..
can anyone help??![]()
Please Login or Register to view this content.
Hello,
I have used this code to protect sheets and i have made it not to select locked cells but when this code runs i can still select the locked cells,..
can anyone help??![]()
Please Login or Register to view this content.
Last edited by SARC777; 08-18-2010 at 08:27 PM. Reason: SOLVED
see EnableSelection in VBE Help
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I looked it up and got an idea,... thanks DonkeyOte........... This is now solved
I was missing this code.
![]()
Please Login or Register to view this content.
Last edited by SARC777; 08-18-2010 at 08:28 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks