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