Button to generate new sheets based on templates

Kurtis2903

New member
Joined
Nov 13, 2015
Messages
1
Reaction score
0
Points
0
Good Afternoon (Uk Time)

i need help in creating a button to generate new sheets based on template.

The spreadsheets attached has for 4 tabs

Constants
Schedule
Summary
Charts

what i need to happen is when the generate button is pressed on information page. it creates blank copies of these templates for new data to be entered.

I need the Constants page to be copied as well but always hidden.

There could be a problem, as vba coding that is already in the spreadsheet is linked to the tab names to make the spreadsheet work.

Also, if i could click the button to generate a blank template it allows me to rename the new tabs to a persons name that would be great. No worries if not

Vba project password is Kurtis2903
 

Attachments

  • Fatigue & Risk Index Calculatornew1.xls
    427.5 KB · Views: 20
Back
Top