400 Visual Basic error message
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: 400 Visual Basic error message

  1. #1
    Guest

    Default

     
    I have a macro button on a workbook(I need it to run on different workbooks). When I click it, it gives me a 400 error message
    It only runs on the workbook where the macro is created
    What should I do?
    Thanks in advance

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

    Default

    would you pls quote the marco you are running??

  3. #3
    Guest

    Default

    Sorry how do you quote the macro?

  4. #4
    Guest

    Default

    When you saved your macro you saved it in "This Workbook Only." It is not available to other workbooks.
    Re due it and save in "Personal Macro Workbook" if your the only user on that machine it should now be available to all workbooks. BTW I never use this as I find it easier to just copy the macro and paste it into what ever new workbook I want it to run in. That way I can taylor the code to do what ever specialities the new workbook may demand.

  5. #5
    Guest

    Default

      
    Sorry, could you tell me where can I find the "My Personal Workbook"
    Thanks

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
  •  

 

 
DMCA.com