+ Reply to Thread
Results 1 to 4 of 4

can we turn our spreadsheets into a distributable application?

  1. #1
    Forum Contributor
    Join Date
    03-07-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    274

    can we turn our spreadsheets into a distributable application?

    Hello,

    A quick question.... is it possible to turn our spreadsheet comprising
    forms with controls on them into a full distributable
    computer application.

    In other words, when one would open the spreadsheet, he would
    see the typical spreadsheet cells and as well buttons
    on the side which open forms. But other than that there would
    be nothing else that gives the impression that it's exce?

    In summary, some excel menus would be taken out,
    the ribbon would not show, the office button would not show and
    the excel logo would not show. Also, scroll bars and the like
    would all be disabled and the user would not be able to
    to reset these changes .....

    all feedback is appreciated

    thanks
    rn

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: can we turn our spreadsheets into a distributable application?

    If you are talking about a Userform

    It should be possible to open a spreadsheet as invisible and get that to open a userform.

    Sorry I used to be able to do this, but not any longer.
    Last edited by mehmetcik; 05-01-2015 at 07:54 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,433

    Re: can we turn our spreadsheets into a distributable application?

    It's possible but you would need to change settings that affect the Excel environment. So, you'd have to make the changes when you activate the workbook and reverse them when you activate another workbook.

    You therefore need to ensure that error handling is robust so that you don't leave Excel "broken".

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: can we turn our spreadsheets into a distributable application?

    Google excel dictator application
    Entia non sunt multiplicanda sine necessitate

+ 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. Replies: 3
    Last Post: 04-13-2009, 12:28 PM
  2. Opening excel spreadsheets via excel.application object w/o prompts
    By Andy S. in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 AM
  3. Opening excel spreadsheets via excel.application object w/o prompts
    By Andy S. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2005, 12:05 PM
  4. Replies: 3
    Last Post: 08-12-2005, 05:05 PM
  5. Turn off Reviewing options at the application level
    By Tracey in forum Excel General
    Replies: 1
    Last Post: 08-05-2005, 08:05 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