• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

HANDY VBA PROCEDURES

CREATE A WORKBOOK WITH A WORKSHEET FOR EACH MONTH

The Annoyance:

I have a group of administrative users who occasionally need to create a workbook with a worksheet for each month of the year. I could do it using a template, but I'd rather automate the process and let them create the workbook by clicking a toolbar button. Is there a VBA procedure I can run that can do this?

The Fix:

The following procedure will do the job. It even names the worksheets with the abbreviated month name and puts the sheets in chronological order!


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint