I do not trust my users to have access to this workbook without it being protected.
Users need to be able to delete rows on a protected sheet.
I want vba code that asks the user what account number they want to delete "What customer ID to delete?"
The vba box should accept a user input for a number, then go to SheetABC finds the matching user input in Column A (if no match is found then respond with a message saying "The account deosnt exist), unprotect the sheet, go to that specific row, delete the row in its entirety, then reprotect the sheet.
For exmaple
VBA msgbox
"What customer ID to delete?"
User input
206700
VBA goes to sheetABC, finds 206700 in column A row 419, unprotects the sheet, deletes row 419, reprotects the sheet.
Users need to be able to delete rows on a protected sheet.
I want vba code that asks the user what account number they want to delete "What customer ID to delete?"
The vba box should accept a user input for a number, then go to SheetABC finds the matching user input in Column A (if no match is found then respond with a message saying "The account deosnt exist), unprotect the sheet, go to that specific row, delete the row in its entirety, then reprotect the sheet.
For exmaple
VBA msgbox
"What customer ID to delete?"
User input
206700
VBA goes to sheetABC, finds 206700 in column A row 419, unprotects the sheet, deletes row 419, reprotects the sheet.