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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Hide VBA in Access2000
- Thread starter JoaoTL
- Start date
1. Distribute Access2000 Runtime to your users. They cant open any object for design (tables,modules,etc). Search the MSDN.
2. Lock your project. Open the VBA Editor. Select Tools>[Project] Properties from the menu. On the protection tab, select <Lock Project for Viewing> so it cant be viewed or edited.
3. You can use the below to disable the <Visual Basic Editor> menu item, however they can still open your project by selecting an existing module or creating a new module. If you dont have 'Microsoft Office 9.0' selected in the references, replace msoControlButton with 1.
Dim oCmd
Dim oItem
Set oCmd = CommandBars.FindControls(msoControlButton, 1695)
If Not oCmd Is Nothing Then
For Each oItem In oCmd
oItem.Enabled = False
Next
End If
Jon Hawkins
2. Lock your project. Open the VBA Editor. Select Tools>[Project] Properties from the menu. On the protection tab, select <Lock Project for Viewing> so it cant be viewed or edited.
3. You can use the below to disable the <Visual Basic Editor> menu item, however they can still open your project by selecting an existing module or creating a new module. If you dont have 'Microsoft Office 9.0' selected in the references, replace msoControlButton with 1.
Dim oCmd
Dim oItem
Set oCmd = CommandBars.FindControls(msoControlButton, 1695)
If Not oCmd Is Nothing Then
For Each oItem In oCmd
oItem.Enabled = False
Next
End If
Jon Hawkins
- Thread starter
- #3
- Status
Similar threads
- Locked
- Helpful tip
