SOLVED

Change the window name with a cell value in a macro

Brass Contributor

 

this file will change name according to the value in cell C2.

after the file is saved i need to update a different file with some simple copy and paste. the problem is that the macro enter in debug mode when execute the line in blue. i believe because the file name change and it wont find the named window any more. so i presume i need the window name in the macro to change when i change the file name or the cell value in C2.

if someone can help me to modify the macro it will be highly appreciated 

thanks again for your time

 

 

olopa67_1-1646028402418.png

 

2 Replies
best response confirmed by olopa67 (Brass Contributor)
Solution

@olopa67 

Change Windows("FFFFFFFFF.xlsm") [I didn't count the Fs] to ThisWorkbook

once again thank you very much Hans
1 best response

Accepted Solutions
best response confirmed by olopa67 (Brass Contributor)
Solution

@olopa67 

Change Windows("FFFFFFFFF.xlsm") [I didn't count the Fs] to ThisWorkbook

View solution in original post