naming worksheets

[parlove]

Hi guys,

I have used this vba worksheet_change function in 2007 and it is not working, it works fine in 2003, however is not changing the worksheet or the target range... can you please advise why. I have saved the workbook as macro enabled but it still does not work

This is carried on from my last thread naming worksheets, the entire code is available in that thread. Although i don't think it is the code as it works perfectly in 2003

Thanks in advance

[shg]

Maybe post the code in this thread?

[parlove]

Please Login or Register  to view this content.

[stanleydgromjr]

parlove,

Please attach a workbook with just the sheet in question - scroll down and see "Manage Attachments".


Have a great day,
Stan

[parlove]

Please see attachment as requested

When the name is changed frmo the drop down in column B column c should automatically change to reflect the name in column b, the corresponding worksheet with the chart should also change, but it is not.

[parlove]

Any ideas on this issue, this code worked in v2003 however is not working in v2007. Thanks in advance for any advice.

[shg]

Seems like something in the workbook is corrupt. When I saved and reopened it, it deleted some stuff and the macro ran fine.

Excel found unreadable content ... Recover?

... then

Removed Feature: External formula reference from /xl/externalLinks/externalLink1.xml part (Cached values from external formula reference)
Removed Records: Formula from /xl/worksheets/sheet7.xml part
Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)

[parlove]

Sorry i am lost, what should i do to my doc to make it work.

When the name in the drop down is selected, it should change the hyperlink name in column C and change the worksheet name it relates to. Did this happen for you?