NewbieUK
06-14-2007, 03:28 PM
HI there - Please forgive me as I am a complete newb when it comes to macros/vba
Sorry to bother you guys but have a query that hopefully someone can help me with - We have a workbook that works as an inventory of documents (ie clicking on a button on the front worksheet takes you to a new worksheet with links to word documents held in the same folder that the workbook is held in). We are about to migrate the server that this sits on to a new server approx 300 miles away (currently it is no more than 30 miles away) but when testing this workbook, it now takes over 3 minutes to open (excel just hangs showing not responding in task manager (I had read somewhere this was due to it likely being under VBA control) where as on the current server it opens within about 5 secs.
My query : is there a way to stop all macros running until after the workbook has loaded (bearing in mind I know next to nothing about VBA)
And if anyone knows anything why this would now taking so long to open then that would be appreciated.
Any assistance would be greatly appreciated.
Thanks
PS My apologies if this is not the correct place to post this query.
Sorry to bother you guys but have a query that hopefully someone can help me with - We have a workbook that works as an inventory of documents (ie clicking on a button on the front worksheet takes you to a new worksheet with links to word documents held in the same folder that the workbook is held in). We are about to migrate the server that this sits on to a new server approx 300 miles away (currently it is no more than 30 miles away) but when testing this workbook, it now takes over 3 minutes to open (excel just hangs showing not responding in task manager (I had read somewhere this was due to it likely being under VBA control) where as on the current server it opens within about 5 secs.
My query : is there a way to stop all macros running until after the workbook has loaded (bearing in mind I know next to nothing about VBA)
And if anyone knows anything why this would now taking so long to open then that would be appreciated.
Any assistance would be greatly appreciated.
Thanks
PS My apologies if this is not the correct place to post this query.