The worksheet probably isn't showing because there's some break in the VBA code that hasn't been reset. Were you tinkering with the sheet when you saved it? Usually just open the sheet outside of BA directly thru excel clear any code errors and resave it, go to the vba editor and check the vba status under the Run tab.