View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe HM Joe HM is offline
external usenet poster
 
Posts: 92
Default Renumber "Microsoft Excel Objects" SheetN (XXX) ...

Hello -

Is there any way to renumber the Microsoft Excel Objects other than
copying/pasting the sheets in the correct order to a new workbook? I
have an Excel file where sheets have been deleted and added quite a
bit and I would like them to be Sheet1 (XXX), Sheet2 (YYY), ... again.

I do not use this name to refer to it (I use the "XXX" instead) so it
will not compromise any of the macros.

Thanks,
Joachim