I'm having trouble with some workbooks I created. It seems that I somehow ended up with 2 or 3 copies of them in the VBA projects list but it won't let me remove any of the projects. Can you offer suggestions to a novice user to clear this up?VBA Projects.jpg
Thanks!!
(Sometimes overlooked or underestimated, but...)
Have you completely closed out of all programs and then restarted your computer? Sometimes Excel can have an overflow and keep a 'memory' so-to-say of things it doesnt need to. If this is the issue restarting should solve that problem.
Well, good news, bad news. That did clear the extra copies. I hibernate my computer every night so I was due for a restart. Unfortunately that didn't fix the problem I was having with my macro not doing what it's supposed to do. I was given this coding:
It works on 2 of my files but not the other 2. Any idea why this wouldn't have added a new worksheet for this week? It worked previously and has added one or two worksheets since creating the workbook.
Please Login or Register to view this content.
Thanks again!
Last edited by AmyV1; 02-10-2017 at 01:50 PM. Reason: add code tags
Post deleted.
Last edited by bakerman2; 02-10-2017 at 09:29 PM. Reason: OP complied to forum rules regarding Code Tags
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Sorry. I'm a complete newbie. I think I have corrected the code format. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks