BrighterLater
Board Regular
- Joined
- Sep 16, 2005
- Messages
- 114
I think I am missing something obvious here but if I have the CodeName of a sheet as a string then can I use it to directly activate the sheet?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Opening a sheet when you have the CodeName as a string
- Thread starter BrighterLater
- Start date
Excel Facts
Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
BrighterLater
Board Regular
- Joined
- Sep 16, 2005
- Messages
- 114
Ok I know how to do it
if the CodeName is Fred, say then
ThisWorkbook.VBProject.VBComponents("Fred").Activate
does it
if the CodeName is Fred, say then
ThisWorkbook.VBProject.VBComponents("Fred").Activate
does it
Upvote
0
Similar threads
- Solved
