VBA / MACRO - naming a worksheet based on a cell value

Hi all. I am using the following vba code to name a worksheet based on a cell (B1) value:

Please Login or Register  to view this content.

The issue I run into is, when B1 is a percentage such as 50%, the worksheet name becomes "0.5 Scenario" instead of "50% Scenario". Is there a way to show "50% Scenario"? Thank you very much.

Thank you very much sweept it works. A follow up question. Now the worksheet name changed, one hyperlink to the worksheet fails (reference isn't valid). The hyperlink is contained in a button in the first worksheet (table of contents) of the workbook. Is there a way to update the hyperlink automatically?

Originally Posted by 6StringJazzer

This will use whatever is in B1 just as displayed, whether it's % or any other format:

Please Login or Register  to view this content.

Hi thank you for the reply. Are you saying the code should be the following?:

Please Login or Register  to view this content.

This does not work for me though. Got a run time error "438".

Originally Posted by ttch

This does not work for me though. Got a run time error "438".

My mistake, go with sweep's solution.

Hi sweep it's just a shape with a hyperlink.

Originally Posted by sweep

OK,

So you can change the hyperlink subaddress to match the sheet name. Something along these lines should work.

Please Login or Register  to view this content.

Thank you very much sweep. Much appreciated.