Issue with Run Time Error when opening file
My workbook executes some code when the file is first opened. Simple things
like selecting a specific worksheet and cell. If I dbl click the workbook name and excel is closed it opens excel, opens the wb and prompts for macros then gets a run time error when doing a Range("B14").select. If Excel is already open and I dbl click the file name it opens the WB and prompts for macros and everything works OK. All suggestions welcome. Thanks, Sandy |
All times are GMT +1. The time now is 12:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com