I am trying to get a list of the 'proper' names of my worksheets for
comparison against other users' names for them.
Here is the sub I wrote to print out the names, but, alas, it will not
do the job.
Public Sub PrintWSNames()
Workbook.Open "C:\MyWB.xls"
For Each ws In Worksheets
ws.Name.PrintOut
Next ws
End Sub
Could someone out there please help me with the proper syntax for the
job?
Thanks a heap
Joanne
Nick Hodge - 14 Aug 2007 22:47 GMT
Joanne
This will create a list of worksheet names in a workbook on a new sheet you
can print.
http://www.nickhodge.co.uk/files/vba/BuildWorksheetIndex.xls

Signature
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog
>I am trying to get a list of the 'proper' names of my worksheets for
> comparison against other users' names for them.
[quoted text clipped - 14 lines]
> Thanks a heap
> Joanne