Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot import package because VBA project is locked

Status
Not open for further replies.

ctwilliams

Programmer
Feb 15, 2002
86
US
I am using Great Plains 7.5 SP2, and have modified one of the Service Advantage reports and added VBA code.

I exported my customizations to a package file, and am able to successfully import this package on my machine.

But when I try to import the package onto a user's machine it says:

Code:
Name                            Type
---------------------------     -----------------------
SVC_Contract_Audit_Trail_MC     Modified Report
SVC_Contract_Audit_Trail_MC     Form with VBA (Locked)

When I click OK to import I get this error:

"Package contains items that cannot be imported because their VBA project is locked".

All dictionaries are local to this user's machine -- none are shared across the network. I have tried rebooting the machine and also logging in to Great Plains as 'sa'. What is locking the VBA file?
 
It is possible to protect VBA projects with a password. Go to the VBA Editor and select the project. Then go to Tools >> <Project Name> Properties and the Protection Tab.

If you don't know the password you might need to delete the VBA file and import the packages again or copy an unprotected VBA file from another workstation.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer
MBS Support - Asia Pacific

Microsoft Business Solutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top