Re-Naming Sheets per Cell data & Hiding Sheets

Hi! I could really use some help setting up my worksheets for 30 products.

on sheet1 I have a button I need to do the following when clicked:
(1) name the next 30 sheets based on cell values in sheet1
(2) for those 30 sheets, hide some of them based on a y/n input in sheet 1

To clarify: the worksheets do not need to be created, they already exist. They just need to be renamed and hidden based on that y/n criteria.

Please see attachment with just 1 worksheet for clarification...
So - The next 30 sheets are to be named by the following ranges (B7:B16), (B21:B30) and (B35:B44)

For every product with a "n" in column C of sheet1, the worksheet for that product needs to be hidden.


I hope this makes sense... any help is GREATLY appreciated.

It would be easier if you arranged the data on Sheet1 in database fashion, adding a column for business unit (if it's necessary), a single header row, and deleting the rows having inconsistent format.

This macro will do what you want. The sheets must be in order. Use a FORMS button instead of a Control Toolbox button, a Form button lets you attach a normal macro stored in a normal module like Module1.

Please Login or Register  to view this content.

EDIT: Tip to SHG, this stuff is easier when standard data layouts are used.

I completely agree with shg but if you must keep it in that format, give this a shot. Little overkill but it gives you some flexibility with adding sheets (business unit D, E, etc)

It assumes all the sheets follow sheet 1.

Please Login or Register  to view this content.