|
|
|
|
#1
09-10-2020, 08:53 AM
|
|||
|
|||
The macros should be in a standard module rather than ThisWorkbook module.
ThisWorkbook is always the workbook containing the code. With what you've posted: ActiveWorkbook is the last workbook opened by the OpenUpFiles macro and ActiveSheet will be the sheet that was active at the time that file was last saved. 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Deleting rows with partially redundant data
|
Noah14 | Excel Programming | 1 | 09-19-2014 11:46 PM |
|
partially delete agenda items
|
Gerreth | Outlook | 3 | 03-13-2012 05:06 AM |
| Partially Obscure Video in PowerPoint | KBsay | PowerPoint | 0 | 10-05-2010 12:49 PM |
| Problems working in a partially protected document | Autumn | Excel | 0 | 02-11-2009 03:46 PM |
| Drawing partially off printed page | DLRA | Visio | 0 | 09-26-2006 10:40 AM |
Windows 10 
Office 2010
Hybrid Mode