Excel with VBA Causing Multiple "other" Workbooks to Open on a Ma

[troutdog8]

Hi,

I am encountering some strange behavior on a Mac when opening workbooks I've written that have VBA in them. The problem is that the Excel:Mac opens not only the particular workbook I intend to open, but it also attempts to open several other workbooks that have been opened on the same machine previously.

Said a different way, it's like the Excel:Mac has somehow remembered which workbooks it's opened that contain VBA in them, and when you open one of them it goes ahead and opens them all.

Any thoughts or suggestions? I have very little experience coding for a Mac (and frankly, i don't want to) so if there are considerations I need to keep in mind, I'd love to hear about them.

Thank you,

Richard

 

[Gavona]

First try opening Excel afresh. Create a new workbook with some simple recorded macro in it. Save the workbook. Exit Excel. Restart excel and open the workbook in whatever way you normally use. Do you get the same unexpected behavior?

Not familiar with the Mac. I am using Excel 2003. What version are you using?

Are you sure that you are opening a workbook rather than workspace? File, SaveWorkspace saves all open workbooks....

When you open one of these books is there a warning and option to enable or disable macros? If so and you choose Disable then do you still get the unwanted behavior?
If you don't get the warning then Tools, Options, Security(tab), Macro Security should be set to medium.

Check Edit, Links are the workbooks that are opening automatically showing here? (Doesn't explain the behaviour but may give a clue).

You are saying that you, personally, wrote the code in these books? And that there is nothing in that code to cause that behavior?

Can the same workbooks be opened from a non-Mac? Is the behaviour the same?

Do you have any workbooks that open automatically when you start excel (eg Personal.xls). Is there any Event driven code in these










Gavin

 

[Gavona]

PS if you are convinced that this is only happening with workbooks containing VBA then start a new thread in forum707 and post to this one that you have done so.

Explain also how you are opening the workbooks (from Excel using File, Open...or from an explorer window)

And if you do File, Save As what file Type is shown?


Gavin