Hi,
I’m wondering what I’m doing wrong here.
I have a Macro designed (not mine) to pick up a person’s name in cell A2 and “save as” when someone choses to save the template.
This macro works in that a file is saved in the right drive under the name in cell A2 however it also crashes the excel program (Excel 2010).
Problem signature:
Problem Event Name: APPCRASH
Application Name: EXCEL.EXE
Application Version: 14.0.4756.1000
Application Timestamp: 4b9c08e8
Fault Module Name: EXCEL.EXE
Fault Module Version: 14.0.4756.1000
Fault Module Timestamp: 4b9c08e8
Exception Code: c0000005
Exception Offset: 00041e17
OS Version: 6.1.7601.2.1.0.256.48
I’m assuming it’s a security thing (might not be) but if other users have to enable security each time they use this file it will be useless. I’m trying to design for users that have current issues in manually choosing the “save as” function let alone the skills for disabling security settings.
Can someone please give me some guidance
Regards
Graeme
Bookmarks