Microsoft Dynamics GP VBA Showing as Locked

Microsoft Dynamics GPI was asked to help a customer with a new Microsoft Dynamics GP client installation as they were encountering some issues with some old VBA customisations. Hearing it was a new server, I wondered if the problem was that they had used Windows Server 2019, on which VBA customisations will not work and will actually cause Dynamics GP to crash immediately.

However, when I delved into the issue with them we found that the VBA customisations were showing as locked in the Customisation Maintenance window ((Microsoft Dynamics GP menu » Tools » Customise » Customisation Maintenance)):

Customisation Maintenance windows showing locked VBA

There is a couple of common reasons for this. The first is that the VBA project is locked; to check this open the Microsoft Visual Basic window and click Tools » Microsoft Dynamics GP Properties:

Microsoft Visual Basic window showing the Tools menu

If the Lock project for viewing box is marked, remove the check and click OK:

Microsoft Dynamics GP - Project Properties window

In the case I was investigating tis box was unmarked, so I followed up looking at the second option; that there is a missing reference. From the Tools menu open the References window and check for any missing components; as the screen shot below shows, there was a missing ReportPrinter component:

References window showing missing reference

Once this component was added to the machine, VBA customisations no longer showed as locked:

Customisation Maintenance windows showing VBA is no longer locked

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Looking for support or consultancy with Microsoft Dynamics GP?

I no longer work with Microsoft Dynamics GP, but the last company I worked for was ISC Software in the UK; if you’re looking for support or consultancy services with Microsoft Dynamics GP you can contact them here.

Leave a Reply

Your email address will not be published. Required fields are marked *