Name Sheets According To Names on Column B and Hide or Unhide Based on Column C

[realbestpete]

Hello Everyone,

I would require a macro to name every sheet on the workbook based on the names given on column B and to hide each one or unhide each one, based on the values
"YES" "NO" on Column C.

I tried looping but I always get an error of some sort.

I have attached a simple workbook showing what I mean.

Thank you!

[Joske920]

Hi,

Question. How do you make sure that the sheet you are going to give the name is the actual sheet you want to name it?
unless it dont matter you need al connection to make sure that sheet 'a' gets the name 'sheet1'

[realbestpete]

Hey, I would use the order as reference, for example, the first sheet in order from left to right, would take the name on "B2", and the value on "C2" would apply to whether it is hidden or unhidden and so on! Thanks!

[Joske920]

Hi,

its a bit dirty but it does work

Please Login or Register  to view this content.

[realbestpete]

Thanks a lot Joske920, it does work! I appreciate it!