+ Reply to Thread
Results 1 to 20 of 20

Only userform display on screen

  1. #1
    Registered User
    Join Date
    11-13-2003
    Location
    India
    MS-Off Ver
    2007
    Posts
    65

    Only userform display on screen

    Hi
    I want to display only userform on screen and all other excel sheet should not be seen as well as no edit, modify workbook.please help how to do setting in excel for that
    mast

  2. #2
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Only userform display on screen

    Have a look at the attachment and let me know if you have any questions.

    abousetta
    Attached Files Attached Files
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Only userform display on screen

    Hi

    You could use Excel's Application Settings (Office Button, Excel Options, Advanced, Display Options for this workbook) and turn off the View sheet tabs. Then Protect the one 'live' worksheet with a password and untick the 'select Locked Cells' when you do so.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    11-13-2003
    Location
    India
    MS-Off Ver
    2007
    Posts
    65

    Re: Only userform display on screen

    Hi
    abousetta
    Userform is working but if I open any other excel file , it is not opening , I want to see or open other excel file for multitasking ,Pl. suggest

  5. #5
    Registered User
    Join Date
    11-13-2003
    Location
    India
    MS-Off Ver
    2007
    Posts
    65

    Re: Only userform display on screen

    Hi
    Richard Buttrey

    Thgis will partially solve my purpose . I want to cret stand alon type application that dones not look like excel so I want to display only userform at the same time I want to open any other excel files for multitasking , by this setting user form is seems to be front and excel sheets are seen in background that I don't want pl. help

  6. #6
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Only userform display on screen

    I would suggest you open a new instance of Excel. Other option would be to make the userform fullscreen so that the application is still visible but covered by the userform.

  7. #7
    Registered User
    Join Date
    11-13-2003
    Location
    India
    MS-Off Ver
    2007
    Posts
    65

    Re: Only userform display on screen

    Hi abousetta

    If I directly double click on any excel file it will not open. I need to open Excel application exe then open that file that is creating problem

  8. #8
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Only userform display on screen

    Have a look at the attachment. It seems to be working fine now.

    abousetta

    P.S. To see the code, you will need to open a different workbook first then this one.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    11-13-2003
    Location
    India
    MS-Off Ver
    2007
    Posts
    65

    Re: Only userform display on screen

    ok working but when I open any other file , this userform is always on top , why it is not minimising, it should minimise in task bar .is it possible?
    thanx

  10. #10
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Only userform display on screen

    Yes, but the coding is a lot more difficult. It taps into Windows API to make the userform similar to a Windows userform rather than an Excel one. I will have to look at this later in the week.

  11. #11
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,163

    Re: Only userform display on screen

    @abousetta,

    The attached xlsm is password protected. I opened it and another workbook and was unable to get past the password block. How do I get to see your code behind the attached above?
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  12. #12
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Only userform display on screen

    No password.. I don't use passwords.

    Open a different workbook (not an empty workbook that is not saved) first. Then open this one. In the visual basic window you will see all the code.
    Last edited by abousetta; 07-03-2012 at 01:10 AM.

  13. #13
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Only userform display on screen

    The code;

    ThisWorkbook:
    Please Login or Register  to view this content.
    Userform1:
    Please Login or Register  to view this content.
    Standard module:
    Please Login or Register  to view this content.

  14. #14
    Registered User
    Join Date
    11-13-2003
    Location
    India
    MS-Off Ver
    2007
    Posts
    65

    Re: Only userform display on screen

    Yes I saw the code , and it was not protected

  15. #15
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,163

    Re: Only userform display on screen

    @abousetta
    Thanks for the code, but I still can't get at the code after opening another workbook and then this workbook. If I open this workbook from the net, I can't save it to my machine. I'm so confused....

    I can't see your workbook in the Project Explorer window, so I don't know how opening your file second helps me see the code.

    I did figure out the "password" problem. I have two add-ins that show in my Project Explorer and was thinking your workbook was one of them. Yours doesn't show. They are password protected.

  16. #16
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Only userform display on screen

    Hi Marvin,

    Try saving the file first instead of opening from the net. I'm using FireFox so it automatically asks what I want to do. Alternatively you can just simple rebuild it (one userform with one button + one standard module).

  17. #17
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Only userform display on screen

    Here is an example created by Stephen Bullen that shows the power of tapping into the Window API for controlling the behavior of userforms.

    Excellent work, much above my level of expertise on the matter.
    Attached Files Attached Files

  18. #18
    Registered User
    Join Date
    11-13-2003
    Location
    India
    MS-Off Ver
    2007
    Posts
    65

    Re: Only userform display on screen

    Yes its quit advance , nice one

  19. #19
    Registered User
    Join Date
    11-13-2003
    Location
    India
    MS-Off Ver
    2007
    Posts
    65

    Re: Only userform display on screen

    Do you have any other way like good web sutes list or any other help for easy and good way of learning excel in advanced,I specifically want to learn VBA and its coding

  20. #20
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Only userform display on screen

    There are a lot of good websites for learning vba as well as books. If you search the site here, this question comes up a lot and many people have provided really good suggestions. I personally began with vba for dummies. It's simple but gives you a lot of important information that is vital for programming in vba.

+ 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