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

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

abousetta

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.

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

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

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.

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

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.

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

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.

@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?

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.

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.

Yes I saw the code , and it was not protected

@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.

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).

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.

Yes its quit advance , nice one

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

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.