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
4479
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 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
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