De-Activating all Formulas in a TAB

[RudeBoy]

Is there an easy way to de-activate all formulas in a TAB easily & then re-activate them?

Normally i have to rename out my =IF statements to accomplish this and then rename them back to activate them.

Thanks for your help

 

[Peter_SSs]

Tried to run vba from M -Mix - Dbls - 1 and received this error?

The worksheet names in the code do not match the worksheet names in post #6. Edit the code so the worksheet names exactly match the worksheet names in your workbook.

 

[RudeBoy]

Perhaps you could start by testing your first two label worksheets (on a backup copy of your workbook):

Sub ConvertToText()

    Dim ws As Worksheet
       
    For Each ws In Worksheets(Array("M -Mix - Dbls - 1", "M -Mix - Dbls - 2"))
        ws.Cells.Replace What:="=", Replacement:="/=", LookAt:=xlPart
   Next ws
 
End Sub
Sub ConvertToFormula()

    Dim ws As Worksheet
   
    For Each ws In Worksheets(Array("M -Mix - Dbls - 1", "M -Mix - Dbls - 2"))
        ws.Cells.Replace What:="/=", Replacement:="=", LookAt:=xlPart
   Next ws
 
End Sub

That works great but as you see I have quite a few tabs to do. Is there a way to Build a Macro to run to do a WaxOff then a WaxOn in one shot?

Are you a Macro Master?

Thanks for your help

 

[StephenCrump]

Yes, it's easily expanded.

Depending on what works best for you, the options include:

- Expanding Worksheets(Array("M -Mix - Dbls - 1", "M -Mix - Dbls - 2")) to include all the worksheets
- Storing a list of worksheets somewhere in the workbook, and looping through that list
- Testing ws.name against a list of worksheets not to be included (if it's a smaller list?)

 

[RudeBoy]

Yes, it's easily expanded.

Depending on what works best for you, the options include:

- Expanding Worksheets(Array("M -Mix - Dbls - 1", "M -Mix - Dbls - 2")) to include all the worksheets
- Storing a list of worksheets somewhere in the workbook, and looping through that list
- Testing ws.name against a list of worksheets not to be included (if it's a smaller list?)

Ok i am a baby crawling when it comes to macros. So i will need some step by step to get it done. So i want to create a WaxOFF macro using the code that renames all the = to /= and then i can create a WaxON macro that puts them all back. Please let me know step by step and i will create the macro i.e go to file, data etc etc thanks