Sounds to me that he is starting two instances of Excel, which will both
open Personal.xls, rather than just opening both files in the same instance.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Jay" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thansk Bob, that's what I thought. One other macro-related question (if I
> may) - when a colleague of mine has more than one excel file open he gets
> the following error message if he tries to use a macro:
>
> PERSONAL.XLS is locked for editing by......
> Open Read-Only or, click 'Notify' to open read-onlu and receive
> notification when the docuemtn is no longer in use.
>
> Could you advise why this is happening and how to prevent it, as he needs
> to use macros with two files open.
>
> Many thanks,
>
> Jay
>
> "Bob Phillips" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Jay,
>>
>> Classic answer ... it depends.
>>
>> If you have just a few macros, it is probably better to put them all in
>> one module, although it shouldn't make any difference, as it will be
>> easier to find them. Just cut them out of the other modules, and paste
>> them into your single module, then delete the empty modules.
>>
>> Conversely, if you have lots of macros, it is probably better to group
>> them into functionally similar modules (e..g. all file I/O macros, all
>> formatting macros). It is also a good idea to give these modules
>> meaningful names, such as mIO, mFormatting, again to aid maintenance.
>> This is how I group my code.
>>
>> After a while, a single module can fail if you put too much code (circa
>> 64K) in there.
>>
>> --
>> ---
>> HTH
>>
>> Bob
>>
>> (there's no email, no snail mail, but somewhere should be gmail in my
>> addy)
>>
>>
>>
>> "Jay" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> Thanks Bob,
>>>
>>> The macros I recorded are saved in personal.xls as separate modules. -
>>> Is it better if they are all in the same module? and if so how is this
>>> done?
>>>
>>> Regards,
>>>
>>> Jason
>>>
>>> "Bob Phillips" <(E-Mail Removed)> wrote in message
>>> news:%(E-Mail Removed)...
>>>> Go to the VBIDE, and select Personal.xls from the project explorer.
>>>> Open the code module and just delete the macro.
>>>> --
>>>> ---
>>>> HTH
>>>>
>>>> Bob
>>>>
>>>> (there's no email, no snail mail, but somewhere should be gmail in my
>>>> addy)
>>>>
>>>>
>>>>
>>>> "Jay" <(E-Mail Removed)> wrote in message
>>>> news:(E-Mail Removed)...
>>>>> Hi,
>>>>>
>>>>> I'm a macro novice and tend to just record them rather than dabbling
>>>>> in VBA.
>>>>>
>>>>> If I save a macro to my personal macro workbook, how do I delete it?
>>>>> as it says I need to unhide personal.xls to do this?
>>>>>
>>>>> Many thanks,
>>>>>
>>>>> Jay
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
|
Similar Threads
