Hide and delete sheets based on cell input

Hi,

I am fairly new in vba.

I have a situation where i would like to hide and delete a few sheets in my worksheet.

there is a few sheets where i want it to be constantly visible and one sheet is based on a cell reference.

the remaining irrelevant sheets i would like it to be hidden and deleted.

How do i go about this?

'always visible are sheets that are constantly visible in all files'
'visible msds is the sheet where my product data is being pulled out based on a input i enter on my first sheet'
the sheets i want to hide and delete will be the remaining irrelevant "MSDS" that i would like to remove through macro.

Please Login or Register  to view this content.

Thanks guys,

Hopefully you all can help me in this.

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Try this:

Please Login or Register  to view this content.