Page 1 of 1

Macro is not there but still runs

PostPosted: Thu Jul 31, 2008 3:10 pm
by Cdasilva
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.

Re: Macro is not there but still runs

PostPosted: Thu Jul 31, 2008 3:30 pm
by Villeroy
Go to Module1, hit Ctrl+A, Ctrl+C. What's in the clipboard?

Re: Macro is not there but still runs

PostPosted: Fri Aug 01, 2008 8:18 am
by Cdasilva
Ctrl A and Ctrl C does nothing so I assume there is nothing in the clipboard. Any other suggestions?

Re: Macro is not there but still runs

PostPosted: Fri Aug 01, 2008 9:17 am
by Hagar Delest
Can you upload the file here (see here: How to attach a document here)?

Re: Macro is not there but still runs

PostPosted: Fri Aug 01, 2008 10:28 am
by Cdasilva
Sorry Hagar file is way too big I can only zip it to a 1000 KB and the sharing file is undergoing maintenance

Re: Macro is not there but still runs

PostPosted: Fri Aug 01, 2008 10:44 am
by Hagar Delest
Even if you remove all the content to keep only the macro modules it's too big?

Re: Macro is not there but still runs

PostPosted: Fri Aug 01, 2008 11:02 am
by Villeroy
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 ;)

Re: Macro is not there but still runs

PostPosted: Fri Aug 01, 2008 11:28 am
by Hagar Delest
But his clipboard seems to be empty!

Re: Macro is not there but still runs

PostPosted: Fri Aug 01, 2008 11:32 am
by Villeroy
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.

Re: Macro is not there but still runs

PostPosted: Fri Aug 01, 2008 11:34 am
by Hagar Delest
It should at least highlight the code.