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: 70
Default Where to store standard macros

The standard approach to storing standard macros is to put them in the
Personal.xls spreadsheet.

I find that this causes a slight problem if I open two instances of Excel. I
get told that personal.xls is already in use, and asked whether I want to
make a read-only copy.

It occurs to me that I can get around this by putting my macros in Book.xlt.
On a quick trial, it seems to work.

So, before I go down that route, what are the problems with doing that?

Thanks

Geoff


 
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
Store array ??? piero Excel Worksheet Functions 4 September 16th 09 04:39 PM
2007 store macros under Menue button as in 2003 Joe Excel Discussion (Misc queries) 1 December 7th 07 09:12 PM
How can you replicate macros for buttons on the Standard toolbar? Suzi Excel Discussion (Misc queries) 1 February 16th 07 09:53 PM
store inventory sheet(ex:sports equipment store) vardan Excel Worksheet Functions 1 October 11th 06 12:51 AM
Where to store macros? chin_un_len Excel Discussion (Misc queries) 3 February 11th 06 11:10 PM


All times are GMT +1. The time now is 02:57 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"