Lost_in_Excel
New Member
- Joined
- Oct 22, 2010
- Messages
- 20
Hi. At work we use a particular workbook each month as simple save it with a new name. This has led to previous workbooks being accidentally overwritten an number of times and giving me several hours of work to reconstruct them.
I've created a template workbook "xxxxxxx_Template" and what I would like is on opening this workbook a macro would check the filename and if the string "Template" is found it prompts the user to save it as a new file.
I've got the msgbox to prompt for the save but it happens on opening every time, for example when the new workbook is saved it now contains the msgbox prompt so I need to check for the "Template" string and not show the dialogue box if it doesn't find it.
I hope I've explained this sufficiently. I made the mistake of adding a couple of very simple macro buttons to hide/unhide columns and now my colleagues think I'm some kind of Excel wizard. I am very much not!!!
Thanks
I've created a template workbook "xxxxxxx_Template" and what I would like is on opening this workbook a macro would check the filename and if the string "Template" is found it prompts the user to save it as a new file.
I've got the msgbox to prompt for the save but it happens on opening every time, for example when the new workbook is saved it now contains the msgbox prompt so I need to check for the "Template" string and not show the dialogue box if it doesn't find it.
I hope I've explained this sufficiently. I made the mistake of adding a couple of very simple macro buttons to hide/unhide columns and now my colleagues think I'm some kind of Excel wizard. I am very much not!!!
Thanks