1. T

    Changing SheetTab name causes VBA to fail

    Hello everyone. It has been my understanding that if we referred to a sheet by its CodeName rather than its SheetTab name, then if someone renamed the sheet, it would not cause VBA to fail. With that thought in mind, I have the following code. The purpose of this macro is to open a second...
  2. K

    sheet tab color change macro

    Hello, I'm using Excel 2007 and Windows XP Basically I'd like to change or not change the sheet tab color automatically dependent on a cell's content or lack of content. I'm using an IF formula that enters a "1" or it remains an empty cell. I want to change that sheet tab color depedent on...

Some videos you may like

This Week's Hot Topics