Hi, I'm looking for some help with the following:
The goal:
I've got multiple identical files ("UserBook") which are used by separate users. One specific copy of the same file ("MasterBook") is located on a shared drive. Each time a specific worksheet within MasterBook is updated, I need all the UserBook files to reflect the changes.
My attempt:
I've got it pretty much figured out. In each of the user files, upon Workbook_Open() I have it compare the date it was last updated (which it gets from a cell value on the worksheet) with the modification date of the master file. If the master file has been modified since the last time the user file was updated, then delete the specific worksheet on the userfile and replace it with the same worksheet from the MasterBook.
The problem:
Even though the UserBook worksheet is deleted BEFORE the MasterBook worksheet is copied over, the worksheet's CodeName is still changed from "wsTheList" to "wsTheList1". This is unacceptabe due to the CodeName being heavily used throughout the rest of the program.
My Code:I tried changing the CodeName before deleting the worksheet:![]()
Please Login or Register to view this content.
This worked great and I thought I was done... but once the VBProject is password protected, this no longer works.![]()
Please Login or Register to view this content.
Any help on this would be much appreciated. I feel like I'm missing something simple...
Bookmarks