+ Reply to Thread
Results 1 to 3 of 3

Saving Macro-Enabled Workbooks

  1. #1
    Registered User
    Join Date
    03-08-2013
    Location
    Washington
    MS-Off Ver
    Excel 2007
    Posts
    2

    Saving Macro-Enabled Workbooks

    Hello,
    I have a spreadsheet that I'm saving with the purpose of people downloading it at work. Emailing it won't work as changes will be made to it weekly and the list of users that I would need to email it to would be very large and difficult to track. The problem I'm running into is when I save it to our website as a Macro-Enabled Workbook it won't load, it just gives a Page cannot be found. If I save it normally it will load just fine, but the file is 5 times as large and people don't know how to enable macros.

    Does anyone have any ideas as to why a Macro-Enabled workbook couldn't be downloaded as a file?
    Thanks in advance

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Saving Macro-Enabled Workbooks

    This is less an Excel question and more of a "why deosn't my Excel file work on my web site" question. Perhaps there is security in place on your site that disables anything known to be "macro-enabled". You may need to hide the true nature of the content by ZIPping it up.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    03-08-2013
    Location
    Washington
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Saving Macro-Enabled Workbooks

    Saving it as a zipped file worked perfectly. Thanks!

+ Reply to 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