Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Macro available in all worksheets

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How can I make a macro available in all excel worksheets by default?

  2. #2
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,919
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-21 01:58, Jean Cox wrote:
    How can I make a macro available in all excel worksheets by default?
    Hi Jean,
    Make it a PERSONAL MACRO, so it will be available in all your WORKBOOKS.
    Eli

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    TO add be careful using Personal in networks, a good and i mean very good IT dept will quash this personal setup on reboot as this is good practice so you loose you work, if thisis not the case then good for this question but draaw into question the network, ok ill be shot for that but that the DIR and location nasty programmers use, remove this and threat gone,

    I would check the IT dept defaults that the administrate, and if Excel is corperate network edition (which it should be!) then this will happen. If local access ????? not so good bit will allow this function,


    So a fix needed i feel....

    The most professional way is to export scripts into default file extentions in the dos atributiry thats ti say -/bas files, these are friendly as apposed to cls and vbs files of cause, can email bas with ease not vbs and cls or exe and com for the VB boys out there, if the security if up to scratch of cause.

    Not export and remane to recall the macro, inport into new wkbooks as needed.

    This is long winded but totally secure and most of all your IT dept wont pester you.

    thisis the ideas behind novel and nt platfroms and sign ins repair custom build to company set defaults, a pain but sadlt thats teh world we live in NASTY... thanks to a few..


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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