ExcelBanter - Get Tab Name to Input Dynamically

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Get Tab Name to Input Dynamically (https://www.excelbanter.com/excel-programming/382421-get-tab-name-input-dynamically.html)

Ardy

Get Tab Name to Input Dynamically

Hello All

If I am using this code ActiveWorkbook.Worksheets("Roster").Unprotect
"Password" How would I automatically get the tab name to input in
Worksheets("Roster"). Portion of the code.

Ardy

Tom Ogilvy

Get Tab Name to Input Dynamically

Is Roster the activesheet? If so

try

ActiveSheet.Unprotect . . .

--
Regards,
Tom Ogilvy

"Ardy" wrote:

Hello All

If I am using this code ActiveWorkbook.Worksheets("Roster").Unprotect
"Password" How would I automatically get the tab name to input in
Worksheets("Roster"). Portion of the code.

Ardy

All times are GMT +1. The time now is 01:47 PM.