Besides XL2BB (which I am going to add to Excel if I can soon enough), has anyone (or does there already exist) VBA code that people trust which it itself writes VBA code to generate entire Workbooks (just the sheets, not the VBA code in any code modules)?
Specifically, it would (in theory) be relatively easy to write a macro which recreates a (moderately sized) Worksheet. (In the past, I have written code to "regenerate" entire Worksheets, just in case the user deleted them and/or dynamically create entire Worksheets if they themselves are needed for VBA code to read off from.)
(And of course, it could be written to only recreate the visible sheets.)
All in all, this is not a personal request. It's a question if something like this can be created for the community to use (and would be accepted), in general. I can be the one to write the tool, if you all want. (But I will only write it if it is something that will be acceptable.)
Specifically, it would (in theory) be relatively easy to write a macro which recreates a (moderately sized) Worksheet. (In the past, I have written code to "regenerate" entire Worksheets, just in case the user deleted them and/or dynamically create entire Worksheets if they themselves are needed for VBA code to read off from.)
- Font formatting
- Cell heights and widths
- Cell formulas
- Named Ranges
- etc.
(And of course, it could be written to only recreate the visible sheets.)
All in all, this is not a personal request. It's a question if something like this can be created for the community to use (and would be accepted), in general. I can be the one to write the tool, if you all want. (But I will only write it if it is something that will be acceptable.)
Last edited: