Hi Folks,
I have a spreadsheet that is hidden from the user (its a blank timesheet master basically). I have another sheet that is not blank called 'instructions', this simply tells the user what to type and where to type.
The hidden sheet is called say "master".
All i want to do is put a simple command button on the 'instruction' sheet that will copy the hidden sheet called "master" and present the user with a dialog to get them to type in the new sheet name ie Dec, Jan or Feb etc. Hit return or ok . And then you simply have a new sheet with a name of their choice, whist keeping the master hidden from danger etc.
Thanx