sspatriots
Well-known Member
- Joined
- Nov 22, 2011
- Messages
- 578
- Office Version
- 365
- Platform
- Windows
Hi,
I have the following in a macro. In an open workbook event, I place the workbook name into cell "F1" on "Sheet1". I have a Workbook_WindowResize event that I want to "Set wbk =" to the workbook in cell "F1" (the workbook name). I have the whole workbook name in the first code below, but I want to write it such that I don't have to put the workbook name in this code. I hope some of this makes sense. SS
I have the following in a macro. In an open workbook event, I place the workbook name into cell "F1" on "Sheet1". I have a Workbook_WindowResize event that I want to "Set wbk =" to the workbook in cell "F1" (the workbook name). I have the whole workbook name in the first code below, but I want to write it such that I don't have to put the workbook name in this code. I hope some of this makes sense. SS
VBA Code:
Dim wbk As Workbook
Set wbk = Workbooks("BAS - Shop Folder Time Tracking Details - 8-18-2023.xlsm")
VBA Code:
Dim wbk As Workbook
Set wbk = Range("F1")