Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 2000 Macros

    I attempted to use macros in a spreadsheet to no avail. I went into Tools/Macro/Macros and deleted them all. I continue to get alert windows opening regarding enabling/disabling upon opening the file and when hitting enter to move among cells. How do I turn that stuff off?

    Thanks,

    Tom

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 2000 Macros

    Excel assums that a file may contain macros if it contains any macro modules. Therefore, you need to delete not only the macros, but also the module or modules they were in.

    Open the Workbook, and press Alt/F11 to open the VB Editor. Find your workbook in the Project explorer. If the Modules folder is not open, click on the plus sign next to it. Right click on any module in this folder and select "Delete module" where "module" is the name of the module you right clicked on. Do this for all modules in the folder.
    Legare Coleman

Posting Permissions

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