LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default open sheet more than once?

Do I understand this correctly?

There is one sheet A, so if function one() opens sheet A, then calls
another function two() which also opens sheet A, there shouldn't be a
problem. Right? When two()returns, one() should still have the same
"handle" to the sheet and should still be able to work with it.

But something is up. VBA is losing its brains somewhere. All of a
sudden simple range assignments fail on sheet A, but also on other
sheets. If I try and investigate and expand the sheet expression in
the Locals window, Outlook tries to install! If I just go ahead and
ignore the error (hit continue) everything seems to work just fine.

Again, about instantiating multiple "handles" on a single sheet. That
should be ok? (I'm not 100% that this is causing the problem, but
first things first.)

Thank you

Xcel 2010, xp
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Right-mouse open a 2nd file to a particular sheet that correspondswith a 1st file's sheet [email protected] Excel Programming 2 August 27th 12 02:22 PM
ON OPEN VBA Code input incorrectly now excel sheet wont open mmartin New Users to Excel 1 February 16th 11 11:33 PM
why, when i open a work sheet does a blank sheet open as well John Excel Discussion (Misc queries) 2 July 7th 07 06:20 PM
Search open sheets in workbook and insert into open sheet punx77 Excel Discussion (Misc queries) 0 March 6th 06 05:07 PM
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet arunjoshi[_5_] Excel Programming 1 May 2nd 04 03:50 PM


All times are GMT +1. The time now is 01:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"