Why it Opens Macro File

K

knikkix

Hi,

I am opening Excel sheet from VB.Net. Suppose the namis VB_WorkBook.xlt

In the WorkBook_ACtivate event, I am activating the following
procedures to activate when the user press the keys. Suppose the name
of this macro file is Macro_File.xls
application.onkey "{Del}", "OnDelete"
application.onkey "{Down}", "GoDown"

My main problem is the sheet is opened ok from Vb.Net but when I opened
another workbook from outside (Outside_Workbook.xls) then it also got
opened in the same excel instance in which vb has opened the workbook.

Close the Vb_Workbook.xls and reopen Outside_Workbook.xls. When I
reopen it then macro_file is automatically attached to it meaning macro
file is also opened automatically. I don't want this macro file to be
opened. what can i do.

Thanks
Nikki
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save workbook without shapes 0
Open file password 13
Apply Excel Macros to another open file 1
How to record a macro within a macro 9
Autorun macro does not autorun... 5
How can I open an Excel Workbook from Outlook macro and activate that workbook? 1
saveas macro help 1
Global Template Network and saving auto texts & macros 2

Top