Can't Find & Replace As Error Comes Up Saying Protected Sheet

[Dazzawm]

I am trying to make wholesale changes to a sheet but Can't Find & Replace As Error Comes Up Saying Protected Sheet. It is not protected as it is a brand new worksheet. I think it may have to do with wanting to change commas for / etc. Any way around this please?

 

[Dazzawm]

Any help anyone please?

 

[Fluff]

If you are getting an error that the sheet is protected, then it probably is.
Check that the macro is working on the sheet you think it is, & that that sheet is not protetced

 

[Dazzawm]

As I said it's a brand new workbook so how can the data be protected, plus I have no macro on it.

 

[Fluff]

Using Ctrl H to replace , with / shouldn't give you a message about the sheet being protected.
Can you use Ctrl h in other sheets in that workbook?