jaminben
02-09-2012, 09:33 PM
Hello,
For some reason my delete sheet command has disappeared from my tabs right click menu. All the other commands are still available and I can disable/enable those just fine with:
Application.CommandBars("Ply").Controls("&Rename").Enabled = False
but
Application.CommandBars("Ply").Controls("&Delete").Enabled = True
doesn't seem to bring the delete back.
The workbook isn't protected etc.
Anyone got any ideas?
Thanks
Ben
Edit
I Should've also said its for version 2007 and its affecting any file I open.... no way to delete a sheet :(
For some reason my delete sheet command has disappeared from my tabs right click menu. All the other commands are still available and I can disable/enable those just fine with:
Application.CommandBars("Ply").Controls("&Rename").Enabled = False
but
Application.CommandBars("Ply").Controls("&Delete").Enabled = True
doesn't seem to bring the delete back.
The workbook isn't protected etc.
Anyone got any ideas?
Thanks
Ben
Edit
I Should've also said its for version 2007 and its affecting any file I open.... no way to delete a sheet :(