The Great Dane
New Member
- Joined
- Dec 6, 2021
- Messages
- 3
- Office Version
- 2019
- Platform
- Windows
Hi all,
I’m new to this so forgive me -
I need a macro to automatically F2 and Enter on one cell for each tab (Cell A1). The reason I ask is that I have a working macro that renames each tab based on the contents of this cell, A1. However to activate the change in tab name I have to click into A1 and enter for the change to take place - I want this to be automatic.
Thanks,
I’m new to this so forgive me -
I need a macro to automatically F2 and Enter on one cell for each tab (Cell A1). The reason I ask is that I have a working macro that renames each tab based on the contents of this cell, A1. However to activate the change in tab name I have to click into A1 and enter for the change to take place - I want this to be automatic.
Thanks,