ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Issue with Run Time Error when opening file (https://www.excelbanter.com/excel-programming/360431-issue-run-time-error-when-opening-file.html)

Sandy

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