Autofilter change opens another document!
 

Autofilter change opens another document!

Hi

i have a document - when i change the autofilter - it runs a macro and
opens another document.

I have looked around the personal.xls and the actual file it doing it
on - i cannot look at the vba behind the document being opened as it is
vba password protected and i have not worked out a way to get into it
(even though i have been asked to by my company as the person who built
it has now left and there are errors in it!)

thanks in advance

Autofilter change opens another document!
 

You will need software to recover a VBA password. Do a Google search for
"VBA Password" and rummage through the offers. It is not free, but many
sites offer a free trial period of their software which is plenty of time to
get yours open and change the password.
Mike F
"Buffyslay" wrote in message
ups.com...
Autofilter change opens another document!

Hi

i have a document - when i change the autofilter - it runs a macro and
opens another document.

I have looked around the personal.xls and the actual file it doing it
on - i cannot look at the vba behind the document being opened as it is
vba password protected and i have not worked out a way to get into it
(even though i have been asked to by my company as the person who built
it has now left and there are errors in it!)

thanks in advance

Autofilter change opens another document!
 

Yeah - thanks. I am aware that this is the way to get a password hack
for VBA, but i was really hoping for some help with the actual
question.

thanks again

Autofilter change opens another document!
 

The code would be in the document with the autofilter. One way to check is
to open the document with macros disabled, then change the autofilter. The
other document should not be opened if the code is in the original document.
(or perhaps just disable events might be sufficient).

Your company should request the author to supply the password (which he/she
probably has a legal obligation to do).

Other than that, your comany can purchase a password cracker (for Excel VBA)
from someone like

http://www.lostpassword.com

--
Regards,
Tom Ogilvy



"Buffyslay" wrote in message
ups.com...
Autofilter change opens another document!

Hi

i have a document - when i change the autofilter - it runs a macro and
opens another document.

I have looked around the personal.xls and the actual file it doing it
on - i cannot look at the vba behind the document being opened as it is
vba password protected and i have not worked out a way to get into it
(even though i have been asked to by my company as the person who built
it has now left and there are errors in it!)

thanks in advance

Autofilter change opens another document!
 

Documents that are closed don't run or trigger macros. They are completely
passive. You say the password protected document gets opened when you
change the autofilter in another document. The "another document" would
have to contain the code to open the password protected document in my
opinion (with other alternatives below).

An alternative scenario is an addin is being loaded that instantiates
application level events. This might be monitoring open workbooks and
opening the password protected document.

another scenario is that one of the menu items has been replaced and
selecting from that menu triggers a macro that is either located in the
protected document or triggers a macro in another document that opens the
protected document. However, you indicated changing an autofilter which I
normally interpret as selecting a dropdown in a column - this usually does
not trigger a macro inherently.




--
Regards,
Tom Ogilvy

"Buffyslay" wrote in message
ups.com...
Yeah - thanks. I am aware that this is the way to get a password hack
for VBA, but i was really hoping for some help with the actual
question.

thanks again