X(Close) Button Disabled in Userform

[Naveed Raza]

Hello Everyone,

I need small in userform can anyone please help me out from this problem.

My question is, In Excel VBA Script, when we insert Userform in userform top right side small X button will be there I mean to say close button , i want disabled that button I tried in properties but i unable to do that please can anyone solve this.

Why i want this is suppose if we create login user id and password form , without entering the details of username and password if we click on that top right side button user easly can access the excel sheet.

Thanks,
mohammad Naveed.

[Alf]

Perhaps this link could be of help?

http://www.j-walk.com/ss/excel/tips/tip80.htm

Alf

[Naveed Raza]

Thanks alot Alf its Nice.

[Naveed Raza]

Hi Arlette,

Thanks for your quick reply and i used ur code and its working nice once again thanks Arlette.

If you don't mind i need one more small help , below is my question.

I want to extract file name which is avialable in particular folder, suppose in C:\temp\ folder total 3 excel files were there with the name of 2054, 2365, 2145 and that would either xls, xlsx , xlsm whatever it may be. I need this file name 2054, 2365 , 2145 in assigned range.

I used this below code but its asking to select path and dialog box also opening, i dont want to open browse to folder option if i run code automatic all the available file name should come.

Please Login or Register  to view this content.

Thanks,
Naveed.