Page 1 of 1
Macro is not there but still runs
Posted: 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
Posted: 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
Posted: 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
Posted: 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
Posted: 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
Posted: 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
Posted: 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
Posted: 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
Posted: 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
Posted: Fri Aug 01, 2008 11:34 am
by Hagar Delest
It should at least highlight the code.