Hi AliH

You can right click on a sheet tab and select all sheets
Change the cell and right click on a sheet tab and ungroup the sheets

With code

Sub test()
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
sh.Range("G14").Value = "Hello"
Next sh
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl


"AliH" wrote in message ...
I have a workbook with lots of worksheets that all have the same layout and
are protected.

I want to make a change to a fomula in cell g14 on all the spreadsheets

How can I do this?