Hi,
If you want to make changes to workbook 2 why are you first wanting to deactivate it only to reactivate it? Is there not some other event that you could use to make the change?
But since you're not using Paste Special Values why not simply point AU29 to G29 with =G29, and similarly for AU30:AU120
You may find the Application.EnableEvents = False instruction of some use in the appropriate place, followed later by an =True instruction.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks for the reply!
To better understand what I'm trying to accomplish with this, please take a look at my older thread:
http://www.excelforum.com/excel-gene...33#post3328333
So, I have two workbooks opened. The first one is a database and the second one is a workbook, where I'm using some comboboxes to select the values from the database. However, everytime I sort some of the database columns, my comboboxes selections are messed up. Because of this, I would like to run this COPY/PASTE macro everytime I switch from the second workbook to this database workbook, so I have those comboboxes selections stored in other cells, in case I would like to sort anything in the database, and later I want to run another macro to paste them back after I sort something in the database workbook.
Does it make sense?
Thanks in advance!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
LukasK 
Register To Reply
Bookmarks