baylorcatholic
New Member
- Joined
- Sep 4, 2012
- Messages
- 8
As my post title states, I am trying to add the sheet name to the center footer for each worksheet in a workbook. The workbook has about 80 sheets and it is cumbersome to do this manually. I am using Excel 2010.
I have tried to record a macro capturing what I do manually, but when I run the macro on another sheet, it does not add the sheet name to the center footer.
I have tried searching for a macro online and the ones I have found just crash excel.
Any help would be appreciated. I know I am probably missing something obvious in my macro code.
I have tried to record a macro capturing what I do manually, but when I run the macro on another sheet, it does not add the sheet name to the center footer.
I have tried searching for a macro online and the ones I have found just crash excel.
Any help would be appreciated. I know I am probably missing something obvious in my macro code.