Enabling or Hide "Delete" option on right click
Our take
The topic centers around a practical challenge many users face when working with spreadsheet tools—specifically, the uncertainty surrounding how to enable or disable the "Delete" option on selected sheets. This issue is especially relevant for professionals who rely on precise controls to manage their data effectively. The article outlines a common troubleshooting approach, where the author attempted to adjust command bars via VBA, only to encounter resistance in newer versions of Excel. It highlights a key point: the behavior varies significantly between older and current spreadsheet environments, which underscores the importance of understanding compatibility and version differences. What stands out is not just the technical workaround but also the frustration it causes, as users invest time and effort to fix seemingly simple issues.
This situation reflects a broader trend in software development, where changes in user interfaces can disrupt previously effective workflows. The fact that the author found the solution in older versions but not in the latest versions speaks volumes about the need for adaptability. Moreover, it emphasizes the value of community support and shared knowledge, as the author turned to platforms like chatgpt and YouTube tutorials to find answers. These resources, while helpful, also reveal a gap in how information is disseminated and accessed by different audiences. It’s clear that clear guidance is essential, especially when precision is crucial for data management.
The article also invites reflection on what this means for future improvements. If users are left guessing about functionality, it raises questions about transparency from developers and the necessity of comprehensive testing across versions. For anyone navigating similar challenges, it serves as a reminder to stay patient and proactive in seeking solutions. Ultimately, the piece encourages a mindset of continuous learning and adaptation, ensuring that even small adjustments can lead to meaningful enhancements in productivity. By addressing these issues head-on, users can regain confidence and efficiency in their workflows.
Hello,
How I can enabled or hide "delete" option on few selected sheets.
So what I have tried is to put this to VBA on selected sheet workbook
Application.CommandBars("Ply").Controls("Delete").Enabled = True or even tried it with False
and nothing happen.
What I understood if tried using this on old excel version except "Ply" would be "Cell...", it wouldve work. But in current new one wont work.
I have asked chatgpt, looked up youtube tutorials and nothing help.
I have also tried this to thisWorkBook and still nothing happen. Can someone help me thx.
Private Sub Workbook_SheetActivate(ByVal Sh As Object) On Error Resume Next Select Case Sh.CodeName Case "Sheet27", "Sheet28", "Sheet29", "Sheet30", "Sheet32" Application.CommandBars("Ply").Controls("Delete").Enabled = False Application.CommandBars("Ply").Controls("Delete...").Enabled = False Case Else Application.CommandBars("Ply").Controls("Delete").Enabled = True Application.CommandBars("Ply").Controls("Delete...").Enabled = True End Select End Sub [link] [comments]
Read on the original site
Open the publisher's page for the full experience