Don't open the VB Editor when a macro is executed

**rajusampathirao** · 05-19-2008, 06:14 AM

Hi
I have a query in Excel 2003.

My question is:
I have a macro created for my Excel. I have a short cut key to run this macro. When i run the macro, the VB editor is opened where i have written the code. My requirement is, I don't want the VB editor to be opened when i run the macro. I want the macro to be executed but the VB editor should not be visible to the user.

Regards,
Raju

**davesexcel** · 05-19-2008, 06:17 AM

Originally Posted by rajusampathirao

Hi
I have a query in Excel 2003.

My question is:
I have a macro created for my Excel. I have a short cut key to run this macro. When i run the macro, the VB editor is opened where i have written the code. My requirement is, I don't want the VB editor to be opened when i run the macro. I want the macro to be executed but the VB editor should not be visible to the user.

Regards,
Raju

Hi Raju,
Does the code work??
That is probably why the VBA editor is opening up.........

**rajusampathirao** · 05-19-2008, 12:01 PM

Hi Dave,

My Code is working fine.
I have written the macro to sort a single column in ascending order.
It is working very fine. But still the VB editor is opened whenever i run the macro.
How to solve this?

Regards,
Raju

**fecurtis** · 05-19-2008, 01:52 PM

Originally Posted by rajusampathirao

Hi Dave,

My Code is working fine.
I have written the macro to sort a single column in ascending order.
It is working very fine. But still the VB editor is opened whenever i run the macro.
How to solve this?

Regards,
Raju

If the macro is working properly, VB editor won't open up. What criteria are you using to run the macro? Is it done by pressing a button, shortcut key, etc?

**davesexcel** · 05-19-2008, 01:54 PM

Originally Posted by rajusampathirao

Hi Dave,

My Code is working fine.
I have written the macro to sort a single column in ascending order.
It is working very fine. But still the VB editor is opened whenever i run the macro.
How to solve this?

Regards,
Raju

Lets see the code...

**rajusampathirao** · 05-21-2008, 12:26 AM

Originally Posted by fecurtis

If the macro is working properly, VB editor won't open up. What criteria are you using to run the macro? Is it done by pressing a button, shortcut key, etc?

Hi
I have called the macro from WorkSheet_Change event.
I have put a condition in that, if all my rows in 1st column are filled, then call the macro. I have written this code in Worksheet_change.

**rajusampathirao** · 05-21-2008, 12:43 AM

Originally Posted by davesexcel

Lets see the code...

Hi Dave,

This is my code...

Iam calling the macro from the event Worksheet_Change, when my last row in the second column is filled.
In Worksheet_Change

Please Login or Register  to view this content.

In the macro SORT_ASC

Please Login or Register  to view this content.

Here Iam sorting the 4th column.

So whenever i enter the values in 2nd column and i fill my last row, then the macro is called and it sorts the column 4. My column 4 values are based on column 2 and 3 values.
Please tell me what could be the problem.

Regards,
Raju

**royUK** · 05-21-2008, 01:44 AM

Is your worksheet code actually in the worksheet module?

**davesexcel** · 05-21-2008, 06:21 AM

Hi,
Very interesting...
This part of the code is taking you to the vba editor

Please Login or Register  to view this content.

You may have to rename that range

**rajusampathirao** · 05-21-2008, 06:55 AM

Originally Posted by davesexcel

Hi,
Very interesting...
This part of the code is taking you to the vba editor

Please Login or Register  to view this content.

You may have to rename that range

Hi Dave....
Thanks a lot...that worked...
I commented the code
Application.Goto Reference:="SORT_ASC".

Thanks again...

Regards,
Raju.

Don't open the VB Editor when a macro is executed

LinkBack

Thread Tools

Rate This Thread

Display

Don't open the VB Editor when a macro is executed

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions