Results 1 to 4 of 4

Open Excel Template in New Session

Threaded View

  1. #1
    Registered User
    Join Date
    10-10-2010
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003, 2007 & 2010
    Posts
    88

    Open Excel Template in New Session

    I have created an interactive form in VBA which removes all menus and command bars when macros are enabled, and handed this over to our IT team. In turn, the IT team have placed the form in Templates over our Network.

    But, many users are facing the problem of all of their other open Excel documents also lossing menus and command bars once the macros in the template are activated.

    Ideally, it would be great to have the Template open in a brand new session of Excel so that it doen't cause any other open documents any grief.

    I didn't realise that the form was going to be distributed via templates, and thought that each relevant user would get their own copy, so now I have to find a solution, like yesterday a couple of years ago.

    At my wit's end, and any help will go greatly towards preserving what little sanity I still have remaining.
    Last edited by davesexcel; 01-13-2011 at 11:04 PM.

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