Macro is not there but still runs

by **Cdasilva** » Thu Jul 31, 2008 3:10 pm

I am programming in VBA to change an Excel sheet. After the file closed and autorecovery- Now I am unable to see one of my macros in Module 1, whilst macro's in Module 2 are visible. Whats even stranger is that the(invisible) macro runs. Please help, it took me weeks to program it.

edit this topic's initial post · by **Villeroy** » Thu Jul 31, 2008 3:30 pm

Go to Module1, hit Ctrl+A, Ctrl+C. What's in the clipboard?

by **Cdasilva** » Fri Aug 01, 2008 8:18 am

Ctrl A and Ctrl C does nothing so I assume there is nothing in the clipboard. Any other suggestions?

by **Hagar Delest** » Fri Aug 01, 2008 9:17 am

Can you upload the file here (see here: How to attach a document here)?

by **Cdasilva** » Fri Aug 01, 2008 10:28 am

Sorry Hagar file is way too big I can only zip it to a 1000 KB and the sharing file is undergoing maintenance

by **Hagar Delest** » Fri Aug 01, 2008 10:44 am

Even if you remove all the content to keep only the macro modules it's too big?

edit this topic's initial post · by **Villeroy** » Fri Aug 01, 2008 11:02 am

Hagar de l'Est wrote:Even if you remove all the content to keep only the macro modules it's too big?

He could also paste his clipboard content for the same purpose

by **Hagar Delest** » Fri Aug 01, 2008 11:28 am

But his clipboard seems to be empty!

edit this topic's initial post · by **Villeroy** » Fri Aug 01, 2008 11:32 am

Ctrl A and Ctrl C does nothing so I assume there is nothing in the clipboard. Any other suggestions?

Hagar de l'Est wrote:But his clipboard seems to be empty!

Copying does not do anything visible, which is why he assumes that it is unchanged.

by **Hagar Delest** » Fri Aug 01, 2008 11:34 am

It should at least highlight the code.

Macro is not there but still runs

Macro is not there but still runs

Re: Macro is not there but still runs

Re: Macro is not there but still runs

Re: Macro is not there but still runs

Re: Macro is not there but still runs

Re: Macro is not there but still runs

Re: Macro is not there but still runs

Re: Macro is not there but still runs

Re: Macro is not there but still runs

Re: Macro is not there but still runs

Who is online