I have this macro that creates a desktop shortcut for the spreadsheet as well as setting up two folders and shortcuts on desktop. This macro worked, but I saved the spreadsheet as a template and now it does not work properly. It saves a shortcut on the desktop, but the path for the spreadsheet is now desktop instead of the documents folder it resides in. How did saving the spreadsheet as a template affect the macro? If there is something else I can do to improve this macro, please post and I appreciate the help. Thanks for any help!

Please Login or Register  to view this content.