I have a need to export my whole sheet to excel without a few objects. For example, if I have 1 table, 1 textbox and 1 listbox on my sheet, I only need to display the table and textbox in a single excel sheet and not the listbox. And the export should be on a single click and not to export each object individually. Can someone provide a macro for that?
And I also want the excel sheet to be named by me and not the default name.
Can the above 2 requirements be combined in a single macro?
