Macro to delete a certain worksheet...

[Closed]
Report
Posts
5
Registration date
Thursday February 21, 2013
Status
Member
Last seen
May 9, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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