+ Reply to Thread
Results 1 to 2 of 2

Permanent macro unspecific to workbook?

  1. #1
    Registered User
    Join Date
    04-18-2007
    Posts
    47

    Permanent macro unspecific to workbook?

    Hi,

    Is it possible to create a permanent macro that is not specific to a workbook?

    To put it plainly, I want to write a simple macro that will execute a simple command (say bold cell C3). I want to do this for hundreds of workbooks, is there a way to write a macro that is persistent between different workbooks?

    Thanks!
    Andy

  2. #2
    Forum Contributor beeawwb's Avatar
    Join Date
    01-04-2004
    Location
    Perth, WA, Australia
    MS-Off Ver
    Microsoft Office Excel 2003 (11.8146.8221) SP2
    Posts
    105
    Put the macro in your personal workbook (Personal.xls) which should be loaded each time Excel starts.

    I have some protect/unprotect macros in mine, so I can set a standard password on each sheet I make, for many workbooks.

    Hope that helps.

    -Bob

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to change the Sheet name of a workbook from a macro present in another workbook
    By ananthakumar.e in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2008, 05:57 AM
  2. Trouble with personal macro workbook
    By MGT2000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-11-2008, 04:19 AM
  3. Importable macro for use with any open workbook
    By ratzy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-28-2008, 11:00 AM
  4. country finder lookup macro
    By theghost in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2007, 10:41 PM
  5. Workbook Name call in macro
    By Dennis Lavallee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-17-2006, 11:46 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1