VBA code to hide sheets and rows

[mari_hitz]

Hi everybody,

Hope you are Ok, I wanted to know if something I am looking for can be done in excel trough VBA. I have a document with several sheets (10), each sheet contains tables with information that several team has to update.
I wanted to know if it is possible to have all sheets hidden, exept for one where the person will have three cells in which they will have to enter information and based on this info the necessary sheets will be shown with only the columns that that person needs to update.

Thanks and regards,

 

[JoeMo]

This could be done in a number of ways. One way would be to have a "sign in" sheet be the only visible sheet when the workbook is opened. Once the user enters his/her name in an assigned range on that sheet, the appropriate sheet for his/her entries would be made visible and after the user has made all of his/her entries on that sheet, the workbook could be saved and closed.

 

[mari_hitz]

This could be done in a number of ways. One way would be to have a "sign in" sheet be the only visible sheet when the workbook is opened. Once the user enters his/her name in an assigned range on that sheet, the appropriate sheet for his/her entries would be made visible and after the user has made all of his/her entries on that sheet, the workbook could be saved and closed.

Thanks JoeMo for your answer! I am sorry, I am newbie in VBA codes. How can I do this. I am trying to search in the web the best codes. Actually I have a sheet in which I have a table with the name of the field and the team who should be in charge to update it. However, I have searched in the web and I cannot seem to find to create a vba code that fits what I am looking for. How can I make to create user and password in excel, how the code should be?

Thanks and regards

 

[JoeMo]

Thanks JoeMo for your answer! I am sorry, I am newbie in VBA codes. How can I do this. I am trying to search in the web the best codes. Actually I have a sheet in which I have a table with the name of the field and the team who should be in charge to update it. However, I have searched in the web and I cannot seem to find to create a vba code that fits what I am looking for. How can I make to create user and password in excel, how the code should be?

Thanks and regards

If you are new to VBA for Excel, this may be a bit challenging. If you PM me I will give you an email address you can use to send me your workbook and some more details about what you want to accomplish and I will try to help.