Q&A: I TRIED GOOGLE ADSENSE BUT WHEN I PUT THE HTML CODE IN IT SAYS YOUR NOT ABLE TO INSERT JAVA SCRIPT?

Try this macro. Change the password to suit, or eliminate if desired.

Open the workbook.

Copy this macro to the clipboard:

Sub Protect_All_Sheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Protect Password:=”Your word”
Next ws
End Sub

Select the appropriate worksheet and right click on the sheet tab.

Click ‘View Code’.

Paste the macro into th module area to the right.

Close back to Excel.

Go to Tools > Macros > Macro

Highlight this macro, if it is not already highlighted.

Click ‘Options’

Select a letter to be used as a keyboard shortcut.

Close back to Excel.

Press Ctrl + your letter to protect all sheets.

To unprotect all sheets in the same manner, use this macro and assign a different keyboard shortcut letter.

Sub Unprotect_All_Sheets()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.Unprotect Password:=”Your word”
Next ws
End Sub