Hi,
Hoping someone can help.
In my spreadsheet I’d like to protect column D from being changed, and columns G & M to have the formulas hidden.
I have a macro to create a dashboard, and a macro to highlight the row.
I need the end users to be able to delete rows so they only send the relevant data to managers.
Is there any way of doing this.
Thank you
Hi, may I ask why you unprotect and protect the worksheet with every selection change?
What's the use of that?
I don't understand the deleting rows part and to leave only relevant data on the sheet?
Sounds quite inconsistent to me.
The adding or deleteing rows can be achieved uisng right mouse click but then I don't understand you
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
The user cannot delete a row if a cell in that row is Locked, even if you allow Delete Row when you protect the sheet.
You will have to provide a button, or double-click, or right-click, or other mechanism for the user to delete the selected row and do it in the code. The attached example adds a button.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
^^^ - Getting slow in old age but also has a button added... Just tacked in at the top of the sheet so no prizes for UI design here... but an alternative might provide some ideas.
Also introduces the UserInteraceOnly option for protection, the OP might like to read up on that.
Last edited by cytop; 05-04-2022 at 10:09 AM.
Hi,
That works perfectly. Thank you.
Would you be able to walk me through adding the button and getting it working.
Who are you asking? There were two solutions posted.
In my case, it's all done in your file. Not sure what you want me to walk through.
Hi, I was asking you 6StringJazzer. The solution works great, however i have to apply it to a work file, and I’m finding it hard to piece together being an excel beginner. I can amend the macro fine, its the button that’s the issue.
Go to the Developer tab.
Under Controls panel click Insert, and in the bottom half (under ActiveX) select the Button icon, and then drag out a button on your worksheet.
Right-click on the button and select Properties to rename the button and update the caption
double click on the button to create the Sub for handling the Click event. You can use the code I provided for that.
I just played around with the file and code.
The range is now a Listobject (table) when you right-click you can either delete the selected row or add a new row and you are prompted to enter a new ID (no check if its already present)
Was just for fun
Hi, i have a pop up, ddmsetup.tmp. Just wondering how to get rid of it and if it came from here, as these are the only files ive downloaded?
Delete it in the code or wherever you placed it
Else a more extended explanation or the attach the file with non-private data
The files are already attached. I’m wondering if its one of the files that I’ve downloaded from this thread. I havent downloaded anything else.
That looks more like an AV warning than anything else. If you're running on a Dell then Dell have a DDMSetup.exe (Dell Display Monitor) and setup programs sometimes create TMP files which will be scanned by your Anti-Virus.
In any case, more information would be needed before anyone can comment for certain. Does the popup have a caption at the top of the window? Any message displayed? Any available buttons/options?
Last edited by cytop; 05-09-2022 at 08:23 AM.
Nothing to do with the Excel file
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks