Tab named the same as a cell

[gjjh25]

Is it possible to have the tab named as the same as what I enter in A1?

[martindwilson]

you can with code try this in the worksheet module for each sheet you need
(code shamelessly cribbed and modified from somewhere else that escapes me)

Please Login or Register  to view this content.

[gjjh25]

Thanks I have copied this to a module, but when I close it and look for macros for the sheet, there are none shown?

Am I doing something wrong?

I am inserting a module into sheet 1 and it shows up as a module, I then close this and go back to the sheet.

Regards

Graham

[martindwilson]

in the work sheet module not a new module it doesn't show in the macros it runs when a1 is changed

[gjjh25]

Ok thanks, I have got that bit to work now.

But i am getting the following error?

[martindwilson]

ooh arr err it did work then stopped i must have missed something in the code ill see if someone else can fix it!

[romperstomper]

You are missing

Please Login or Register  to view this content.

before you try to refer to the worksheet which may not exist.

[royUK]

Try this

Please Login or Register  to view this content.

Place the Function in a standard module

[snb]

Please Login or Register  to view this content.

[gjjh25]

Thank you that has worked

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[Marcol]

Possibly this in the Workbook Module?

Please Login or Register  to view this content.