Closed Thread
Results 1 to 2 of 2

Vba problem

  1. #1
    Registered User
    Join Date
    07-20-2010
    Location
    london, england
    MS-Off Ver
    Excel 2007
    Posts
    67

    Vba problem

    Hi Guys,

    I have a test spreadsheet that finds your user name and the date and time when you first open it and then if you were to save it and then open it again it wont change as the fields are already full. this is beacuse the form is only changed once and then saved somewhere else and so the template never changes.

    the problem is I can only get it to work on my computer and if i copy and save it into other peoples drives it doesnt work when they open it.

    any thoughts on how to fix it?

    Thanks!!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-17-2007
    Location
    Washington, DC
    Posts
    103

    Re: Vba problem

    Is it possible that their trust center is not set up to enable the macros on this workbook? They might have that annoying pop up bar at the top that needs to be enabled before the VB auto_open will run.

Closed Thread

Thread Information

Users Browsing this Thread

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

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