VBA stops after copying worksheet

**galgonair** · 08-21-2012, 07:55 PM

I have been working on vba code to update a worksheet, now the code stops running when it copies a worksheet from one workbook to another. But this only happens when I try it at work. Both workbooks are .xls, since not all users have 2007 or greater. The VBA code works fine on my personal laptop.

If I run the VBA directly from the VBA editor I'm prompted to enable macros and then it works. If the code runs as progrmmed it stops after the first .copy After:= event.

This code used to work until about 2 weeks ago. I have no idea what the network admin has disabled to prompt for macro in every workbook, but it's stopping the code from completing.

Is there a way to stop the code to prompt to enable macros in the second workbook?

**Richard Buttrey** · 08-21-2012, 08:01 PM

Hi,

Perhaps they've moved the Excel file from a 'Trusted' location to a non trusted location. Or reset the Security level from Low to Medium or High.

Check the Application option settings.

**galgonair** · 08-21-2012, 08:16 PM

Macro securities are grayed out and cannot be changed from Disable all Macros with notification.

I'm using Application.EnableEvents = False to stop the macros in the second workbook from taking over and not returning the the first workbook. Like I said it was working both at home and at work up until about 2 weeks ago.

When I enable the content in the first worbook at home they are enable when the second workbook opens. This is no longer happening at work content must be enabled for every workbook

**Richard Buttrey** · 08-22-2012, 05:05 AM

Please clarify which versions of Excel you have at home and work and which Application Macro settings are set in each location.
Which version is not working, Home or at Work?

Whichever location is greyed out, was the Excel App installed with the "install "with VBA components" parameter set. I understand that the default security settings can be set by your network Admin. Have you asked them what settings they used when installing?

Is the work Excel App in an Microsoft Enterprise environment?

**galgonair** · 08-22-2012, 06:54 AM

I'm using 2002 thru 2010 at home, all versions are set to prompt to allow macros (olderr versions are sett at medium, newer version disabled with notìfication. Work is 2007 and macros are set disable all with notification and cannot be changed.

All version work at home.

I'm convinced that admin has changed some security setting