Forum Discussion

gymsmalta's avatar
gymsmalta
Copper Contributor
Apr 28, 2020
Solved

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 warn...
excel
  • JKPieterse's avatar
    JKPieterse
    Apr 28, 2020

    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 Sub

    Save-as your file to the xlsm type (Excel workbook with macro's) 

JKPieterse's avatar
JKPieterse
Silver Contributor
Apr 28, 2020

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 Sub

Save-as your file to the xlsm type (Excel workbook with macro's) 

gymsmalta's avatar
gymsmalta
Copper Contributor
Apr 29, 2020

JKPieterse 

 

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/

 

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Apr 29, 2020
    I'm afraid you cannot use vba in web excel.

Resources