I've created a user form template where the user will input in some fields and click a button "add to database" then the input will be moved to another worksheet and all the content in the "input" sheet will be cleared
the problem is that when i try to lock any cell in the input sheet the clear content VBA will not work
is there a way to run a clear content VBA on a locked cell at the end i need to lock cell D11 and cell D13 in the "Input" sheet
Please Login or Register to view this content.
Last edited by FDibbins; 02-09-2017 at 03:08 AM.
Have you tried unlocking and then re-locking the cells in the VBA?
I tried to lock the cells by another VBA code but also the clear content vba is not working
I'm new to VBA so if locking and re locking will solve the problem, please advice how to do that , it will be a new macro or just modify the existing one ?
If it is a modefication , plesse advice what and where should i add to the above code
May you upload a sample workbook?
Teach me Excel VBA
And specify which cells you want to lock/unlock
I've uploaded the sheet
Current behavior:
When i input the data in "Input" sheet
it is getting fetched in the "Consolidated sheet" and all the content will be cleared from the "Input" sheet to be ready for inputting another data.
Required behavior:
I just want the macro to work as it is while locking the following fields against any user editing
1 - (D11)" & (D13) in sheet "Input"
2 - "Consolidation" sheet, so that user can only view the data in this sheet without the ability to edit
Thank you so much
See if the attached helps you.
This is extremely helpful
Really thank you so so much Imran
but is it possible to do the first part also (Point no. 1)
which is also locking (D11)" & (D13) in sheet "Input" ??
In sheets Input I have only locked D11 and D13 while the other sheets are fully locked for editing except the information transferred from your form.Originally Posted by Ahmed519
Do you want to lock all cells in sheet input except D5,D7 and D9?
Yes please, I want to also lock all cells in sheet "input" except D5,D7,D9 so users can only edit those three cells only in the whole workbook. Really thank you so much for your great help
I have done it for you if you need to un protect the sheets for further formatting the password is 123.
I'm really appreciating your help
Thank you so so much
You are welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks