Activating a workbook using VBA code while using Addins

  • Dear All

    I have made an excel addin using VBA code and that addin contains an excel file which have some data in it. While that addin creates a ribbon menu and then in opened excel sheet different tasks are performed.
    in VBA code i refer that addin excel sheet as "Thisworkbook" while the file which is opened and operations are performed on it is "activeworkbook".
    If i open another excel workbook then my code confuses in selecting who is "activeworkbook".
    kindly suggest if there any way that while clicking on a worksheet it becomes activate?
    or some mean that a workbook which i m viewing becomes active?
    With Name i could not do that as the code is very complex and lengthy.

    Thanks in advance

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!