joshcas
06-21-2013, 12:20 PM
Hi,
I'm working on a very tricky macro and I'm running out of ideas.
Basically in column A you have all the names of the worksheets in the workbook.
Columns B to E you have the name of the file that it should generate (headers) and the property to make the sheets visible or invisible.
So the macro would generate new files (Copy the current file) (the new name would be the header) then it would open the new file or better yet closed and it would hide or show the tabs depending if it says show or range (Visible=True) but if it says hide, it should hide it .
The tricky part is that they could add more columns to the right to generate new files , so that would have to be dynamic, how we can do this ?
Any help would be much appreciated
10167
I'm working on a very tricky macro and I'm running out of ideas.
Basically in column A you have all the names of the worksheets in the workbook.
Columns B to E you have the name of the file that it should generate (headers) and the property to make the sheets visible or invisible.
So the macro would generate new files (Copy the current file) (the new name would be the header) then it would open the new file or better yet closed and it would hide or show the tabs depending if it says show or range (Visible=True) but if it says hide, it should hide it .
The tricky part is that they could add more columns to the right to generate new files , so that would have to be dynamic, how we can do this ?
Any help would be much appreciated
10167