Results 1 to 3 of 3

VBA that opens Excel in new Window

Threaded View

Jonata VBA that opens Excel in new... 05-03-2014, 12:04 AM
:) Sixthsense :) Re: VBA that opens Excel in... 05-03-2014, 12:55 AM
Kaper Re: VBA that opens Excel in... 05-03-2014, 12:56 AM
  1. #1
    Registered User
    Join Date
    04-22-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2

    VBA that opens Excel in new Window

    Hi
    I have a project were i have to make a macro and place in a workbook such that as soon as i open that excel file
    1. excel workbook is opened in New Excel window
    2. Ribbon is hidden for this new window.
    So when user closes this excel window there is no problem with other workbook ribbon, as there are open in different window

    i have tried with code stated below it hides the ribbon but new excel window is not open

    Private sub Workbook_open()
    Application.ExecuteExcel4Macro "Show.toolbar(""Ribbon"",False)"
    End Sub

    please help
    Last edited by Jonata; 05-03-2014 at 12:09 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Embedded Excel app opens new window in IE9
    By RichFHill in forum Excel General
    Replies: 0
    Last Post: 08-12-2013, 06:34 AM
  2. How to set the window size when Excel first opens?
    By sethym in forum Excel General
    Replies: 2
    Last Post: 10-16-2011, 07:59 PM
  3. [SOLVED] Excel opens all workbooks within the same app window.
    By rana in forum Excel General
    Replies: 2
    Last Post: 01-27-2006, 05:20 AM
  4. [SOLVED] Office XP: Excel only opens in one window.
    By OfficeXPUser in forum Excel General
    Replies: 3
    Last Post: 08-11-2005, 12:05 PM
  5. Excel 2k opens 2 sheets within same window
    By sphilip in forum Excel General
    Replies: 2
    Last Post: 06-14-2005, 05: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