How to remove path from macro reference
When I move a workbook to another location and call a macro, it might still
refer to the old location and will not work. I would like my macros saved without path. Please, advise me. sn |
How to remove path from macro reference
Code the macro in the sheet rather then a module. This way when the sheet is moved the code moves with it. -- patrickcairns ------------------------------------------------------------------------ patrickcairns's Profile: http://www.excelforum.com/member.php...o&userid=31790 View this thread: http://www.excelforum.com/showthread...hreadid=515056 |
How to remove path from macro reference
Code the macro in the sheet rather then a module. This way when the sheet is moved the code moves with it. -- patrickcairns ------------------------------------------------------------------------ patrickcairns's Profile: http://www.excelforum.com/member.php...o&userid=31790 View this thread: http://www.excelforum.com/showthread...hreadid=515056 |
All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com