Hi Guys,
I'm a complete and total idiot and have broken the first rule and wondering if anyone can help. I'm a total amateur with VB and was looking for a way to protect the cut, copy and paste functions on a workbook; I found a VB code and cut and pasted it straight in. It worked and I was happy but now the cut, paste and copy functions are blocked in the whole of excel not just that workbook. I deleted the code and macros etc and reset using
application.commandbars("cell").reset
in the immediate pane, this has cured right click and keyboard functions but not the edit menu.
Added to this the workbook says that the macro is still there (although I cant find it on VB editor or by unhiding) and it wont let me unprotect the workbook (which was originally protected but then unprotected when I pasted in the VB code).
*Edit* Just noticed I can't drag and copy either. And also its still warning me about macros even though they are all deleted, I've tried the solutions listed elsewhere but to no avail.
All signs point to a dodgy code but i've not the first clue what to do now. If anyone can help however little it would be much appreciated.
Just to clarify, this is happening on my entire excel - not just this workbook. The macro warning is just this particular workbook but everything else is a problem on all.
Yours incredibly stupidly,
Ben
Bookmarks