We bought an older home that had been completely gutted and restored, but the heating system is still a little primitive (we have to manually turn on the gas supply when we use it). When we turn the heater gas off, our carbon monoxide detectors go off and I end up opening the windows b/c I'm paranoid, and that defeats the purpose of using the heater in the first place. Should we continue to use the heater as is, or is there a leak somewhere that we should be worried about?? Thanks!
the green light indicates that the device is working and armed.
This macro will: Unprotect the worksheet, allow for user input to add to the text in cell A1 without modifying the original text, add the inputted text to the original text, and reprotect the workbook. Open your workbook. Copy this macro to the clipboard Sub Modify_Cell_Text() ActiveSheet.Unprotect Userinput InputBox(Please enter the text to add, Edit Cell Text) [A1] [A1] + Userinput ActiveSheet.Protect End Sub Next press ALT + F11 Insert Module Paste the macro into the module at the right. Close out of the VBE back to Excel Select Tools Macro Macros The macro Modify_Cell_Text should already be highlighted. Click: Options Assign a keyboard shortcut letter to apply to the macro. ( I usually use 'a' due to its proximity to the Ctrl key) Close the window and return to Excel To play with it, enter 'Original text' in cell A1 and protect the worksheet (Tools Protection Protect Sheet. Do not set a password at this time. Press Ctrl + a ( or whatever letter you assigned above). When the inputbox appears enter 'has now been modified' and click 'OK'.
