I've a test workbook with lots of sheets and many different macros in it that I used to test VBA code I've learnt.
I've been using:
Sub activateSheet(sheetname As String)
'activates sheet of specific name
Worksheets(sheetname).Activate
End Sub
in an attempt to activate a specific worksheet. However, whenever I press play, a box pops up containing every other macro in the workbook except this one, so that I can't run my activateSheet macro. Is there any reason why this would happen in particular?
I've been using:
Sub activateSheet(sheetname As String)
'activates sheet of specific name
Worksheets(sheetname).Activate
End Sub
in an attempt to activate a specific worksheet. However, whenever I press play, a box pops up containing every other macro in the workbook except this one, so that I can't run my activateSheet macro. Is there any reason why this would happen in particular?
