Macro to delete a certain worksheet...

Closed
m_albges Posts 5 Registration date Thursday February 21, 2013 Status Member Last seen May 9, 2013 - Apr 16, 2013 at 12:00 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 17, 2013 at 05:27 AM
Hello,

I was previously helped out with the following macro:

https://ccm.net/forum/affich-689536-generate-excel-workbooks-based-on-excel-list

The one final thing that would be useful is that when the file has been copied with the relevant information in it, it would delete (or hide) the worksheet with the list in so that the forms would retain just the information that we are going to be working on.

So perhaps there is a final line of code I could add in to hide the list in the first worksheet?

Any suggestions gratefully received!

Thanks,
Matt.

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 17, 2013 at 05:27 AM
You can generate what you want yourself. Quite simple infact

1. open excel file
2. start macro recorder
3. apply operation to the sheet (hide / clear/ delete etc)
4. stop recorder

you have your macro
0