![]() |
|
#1
|
||||
|
||||
![]()
In the VBA Editor while looking at the macro...
Go to Tools > References. This opens the References dialog In the References dialog, find Microsoft Forms 2.0 Object Library and put a tick beside it and press OK If the References dialog doesn't show Microsoft Forms x.x Object Library, click the Browse... button and an Add Reference dialog appears (with the System32 folder open). Find the FM20.dll file and select it and click the Open button. This returns you to the References dialog and you should now see the object library in the list and it will be ticked. Click the OK button to close the References dialog. Go to Debug > Compile Project and you should now see that line in your code is now accepted IF any of the menu commands are greyed out, click the Reset (square) button on the toolbar to stop the macro - when a macro is paused, some of the menu commands are not available.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#2
|
|||
|
|||
![]()
Guessed,
Thank you for your reply, I will take some time with it soon. I am working 12 hour days here, so I don't have a lot of time. Yesterday they said some of us should come in on Sunday too! I am all by myself with MACROs but they have several of us trying to learn PowerShell to use with Active Directory. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
gsrikanth | Excel Programming | 2 | 03-28-2022 06:32 AM |
![]() |
bennyamy | Excel Programming | 4 | 03-23-2017 11:42 AM |
![]() |
OTPM | Project | 3 | 01-02-2014 01:47 PM |
![]() |
tinfanide | Excel Programming | 2 | 06-09-2012 10:19 AM |
![]() |
Manit | Excel Programming | 4 | 12-08-2011 07:35 PM |