Code stopped working, can no longer copy and save a worksheet

**Oracle** · 07-30-2012, 06:06 PM

Hi everyone,

So I have a problem. I have been working on this application for the past couple weeks and I have this module of code that copy's a worksheet into a new workbook and changes everything into values. However I have added buttons onto this sheet and after running the code again it froze the program, in which I had to manually end. It gave an error afterwards however I don't remember what it said. Now everything I try to run or step through it, nothing happens. And before anyone asks, yes I have turned Events and ScreenUpdating on.

I would also like to note that it won't allow me to perform actions like unhide sheets or unprotect them. The code has not been changed either so I have no idea what has happened to disable all functionality.

Ideas???

Much appreciated,
Curtis

---------- Post added at 04:06 PM ---------- Previous post was at 02:56 PM ----------

This issue has been resolved. I reverted to a previous save version and the issue has not occurred again. Not sure what happened.

**Cutter** · 07-30-2012, 07:35 PM

@ Oracle

Based on your last post it seems that you have resolved your issue but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.