Workbook Tab names

[Mike1w]

Locked.

Reason: Duplicate Post

Please read forum rules

http://www.excelforum.com/showthread...76#post1802176


I currently have workbook with multiple worksheets (tabs), each tab is named after cell “A1” by utilizing the following code:

Please Login or Register  to view this content.

Then I have in another the code listed below:

Please Login or Register  to view this content.

This allows me to get information from additional tabs by just entering the tab name “filevalue” and running the associated macro. The problem is that whenever I use the “-“symbol excel has a problem with it, and I need it for my sheet titles, is there a way to modify the VBA to change any “-“symbols to “.” When labeling the tab from the information from the cell indicated. The “.” Allows the macro to work but for some reason when I use the “-“everything goes haywire. Thanks in advance.