do this:

select a single cell on a sheet that you're wanting the said tab eliminated from

hit the Alt and F11 keys at the same time ~> this opens the Visual Basic Environment

on the menu line click Insert

from the drop down click Module

copy and paste the code from #2 into this new Module

hit the Ctrl and g keys at the same time ~> this opens the Immediate Window

place your cursor anywhere in the sub you pasted into the module

hit the F5 key

does anything appear in the Immediate Window ?