+ Reply to Thread
Results 1 to 3 of 3

Overnight Macro/VBA button not working.

  1. #1
    Forum Contributor
    Join Date
    02-26-2014
    Location
    Aylsham, Norfolk, UK
    MS-Off Ver
    Excel 365
    Posts
    126

    Overnight Macro/VBA button not working.

    Hi All,

    I have looked through the forums but could not find anyone with the same problem. I am running version 2013.

    I have had an Excel document which has been working for years literally, and worked fine with this version of Excel. It opens up with what is essentially a cover page. The cover page has nothing but multiple images on it, from that you simply click one of these images and it runs a very simple recorded VBA script for each button image.

    I have checked the VBA and it is all intact (very simple visible not visible with a final sheet selection). I have checked that all the sheets are still intact and none of the names have changed.

    I can select the image but no action takes place the image has the following in the formula bar
    =EMBED("Forms.Image.1","")
    And the image has the name that was associated with it in the Selected Cell area to the top left of the column/row refences.

    If I right click and check for properties it gives me the properties for the entire sheet and nothing else. All of the Macros appear to have disappeared.

    Has anyone come across this kind of thing before? Is there a simple fix?

    I have also tried to insert a new ActiveX image but it simply says cannot insert object.
    I can record new Macros but not create them.

    I have adjusted the settings the allow without restrictions for both Macros & ActiveX. Any assistance would be greatly appreciated.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: Overnight Macro/VBA button not working.

    Check this out. This may be the issue.

    http://www.excelforum.com/the-water-...ms-update.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    02-26-2014
    Location
    Aylsham, Norfolk, UK
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Overnight Macro/VBA button not working.

    Thank you so much for that, deleting the exd files is what solved it for me!

+ 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. [SOLVED] Save (macro) button not working
    By Mr_Nick666 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-18-2013, 09:40 PM
  2. [SOLVED] Macro Button on Worksheet Not working
    By Cyd44 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-29-2012, 01:08 PM
  3. Form (button) Macro not working
    By ufopilot3 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2012, 10:37 AM
  4. [SOLVED] Keep macro running overnight?
    By JeffMelton in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2006, 03:50 PM
  5. How do you run an excel macro automatically overnight?
    By Scott J in forum Excel General
    Replies: 1
    Last Post: 01-06-2006, 02:00 PM

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