Hi (BIG NEWBIE!!)
Wrote a code as per below, but it runs in all active workbooks.
How can I define the code that it only runs for a specific workbook?
Thank You
Please Login or Register to view this content.Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by arlu1201; 08-02-2012 at 05:04 AM.
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi
Appologies for not using tags
Do you perhaps have any idea of how I can adjust my code?
Thank You
It will be good if you explain what you are trying to achieve.
I want the code to run on only one workbook and not on the active workbook.
The problem I am currently having is that pivots must update on "Workbook A" every minute, but when I am working on "Workbook B", excel tries to update those pivots as well, causing it to crash.
Please help as I need a "Live Spreadsheet" ASAP for the company.
Thank You
In place of the "activeworkbook" object, using the "thisworkbook" object will cause the code to run on the same workbook containing the code independent of which workbook is active. Is that what you are looking for? If not, you will need to substitute an object referring to the specific workbook in question in place of the "activeworkbook" object.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks