Forum Discussion
How can I disable the Warning Pop ups on protected cells to make the document more user friendly
How can I disable the Warning Pop ups on protected cells to make the document more user friendly?
All celled are protected and formulas hidden. Each time the protected cell is clicked on the warning popup 'This sheet is Protected. Some parts may be view-only and cant be changed'
I just want to be able to disable this pop up, if anyone can help? 😕
gymsmalta If you can use a bit of VBA, you can prevent that like so:
- Right-click the sheet tab and choose "View Code"
- Paste this code into the window:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Cells(1, 1).Locked Then Cancel = True End SubSave-as your file to the xlsm type (Excel workbook with macro's)
4 Replies
gymsmalta If you can use a bit of VBA, you can prevent that like so:
- Right-click the sheet tab and choose "View Code"
- Paste this code into the window:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Target.Cells(1, 1).Locked Then Cancel = True End SubSave-as your file to the xlsm type (Excel workbook with macro's)
Hi Jan
Thanks so much for replying to my post about about disabling the warning popups in excel.
I hope you may be able help further on the same thing. The solution works perfectly within the excel spreadsheet, and now the warning popups are no longer. But when I then embed the document using excel online in to an iframe, the warning popups return.
This is a test link to the table on the webpage: https://gymsmalta.com/100-test-table/
- I'm afraid you cannot use vba in web excel.
It worked perfectly many thanks, saved me hours and hours! - Thanks
