Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mohan
 
Posts: n/a
Default Macro in Personal.xls

Hi,
im using Excel 2003. I have recorded a macro for some formating things
and sored it in personal.xls. The Problem is when i open more than one excel
at a time it is notifying that Personal.xls is read only how can i avoid
this! Thanx in advance
  #2   Report Post  
Norman Jones
 
Posts: n/a
Default

Hi Mohan,

Given that you can open multiple workbooks in a single instance of Excel,
why are you opening multiple instances of Excel?

If you do have a requirement to open more than one instance of Excel, then
Personal.xls can only be opened as read-only in subsequent instances.

---
Regards,
Norman



"Mohan" wrote in message
...
Hi,
im using Excel 2003. I have recorded a macro for some formating things
and sored it in personal.xls. The Problem is when i open more than one
excel
at a time it is notifying that Personal.xls is read only how can i avoid
this! Thanx in advance



  #3   Report Post  
Mohan
 
Posts: n/a
Default

Thanx Norman Jones.

"Norman Jones" wrote:

Hi Mohan,

Given that you can open multiple workbooks in a single instance of Excel,
why are you opening multiple instances of Excel?

If you do have a requirement to open more than one instance of Excel, then
Personal.xls can only be opened as read-only in subsequent instances.

---
Regards,
Norman



"Mohan" wrote in message
...
Hi,
im using Excel 2003. I have recorded a macro for some formating things
and sored it in personal.xls. The Problem is when i open more than one
excel
at a time it is notifying that Personal.xls is read only how can i avoid
this! Thanx in advance




  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

Only open Excel once!

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mohan" wrote in message
...
Hi,
im using Excel 2003. I have recorded a macro for some formating

things
and sored it in personal.xls. The Problem is when i open more than one

excel
at a time it is notifying that Personal.xls is read only how can i avoid
this! Thanx in advance



Reply
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
Can't get simple macro to run Abi Excel Worksheet Functions 5 January 12th 05 07:37 PM
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 01:27 AM
Macro and If Statement SATB Excel Discussion (Misc queries) 2 December 3rd 04 04:46 PM
Macro Formula revision? Mark Excel Worksheet Functions 1 November 28th 04 01:43 AM
Macro for multiple charts JS Excel Worksheet Functions 1 November 19th 04 03:44 AM


All times are GMT +1. The time now is 09:53 PM.

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"