+ Reply to Thread
Results 1 to 2 of 2

Enable excel 2003 Command Buttons in excel 2007

  1. #1
    Registered User
    Join Date
    07-17-2007
    Location
    Buenos Aires
    Posts
    12

    Enable excel 2003 Command Buttons in excel 2007

    I have programmed VBA command buttons in an excel 2003 file, and want to know how to use them in excel 2007. I have saved the file as Macro-Enabled workbook, and enabled macro execution through Trust Center settings. I can see each of the Command Buttons code programming by right-clicking on any of them. But there is no way to click on the buttons and execute the code programmed for each of them. Any idea how to enable these commands buttons in excel 2007?

  2. #2
    Registered User
    Join Date
    07-17-2007
    Location
    Buenos Aires
    Posts
    12

    Thumbs up Re: Enable excel 2003 Command Buttons in excel 2007

    Hi, I continued investigating the issue and finally found an explanation: All Comand Buttons that were created using excel 2003, appear as "Locked" when the file is opened in excel 2007. So the solution is as follows: 1) Open the file in excel 2007, go to "Design Mode" and open the visual basic window. 2) Open the "Properties" window and review the status of line "Locked" for all CommandButton's. Status must be changed from True to False in order to enable CommandButton execution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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