Hi all!!
I want to ask other than ActiveWorkbook.Sheets and ThisWorkbook.Sheets, does it have other functions similar to this?
As I want to automate the process using a button but the workbook is under ActiveWorkbook, which means I have to open that active workbook to run the code.
Any function that can run when the active page is under ThisWorkbook?
I want to ask other than ActiveWorkbook.Sheets and ThisWorkbook.Sheets, does it have other functions similar to this?
As I want to automate the process using a button but the workbook is under ActiveWorkbook, which means I have to open that active workbook to run the code.
Any function that can run when the active page is under ThisWorkbook?