• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How Open this excel file.

JAMIR

JAMIR

Member
Dear Sirs,

I have created excel file with login form. But i have make little bit changes in code of user initilization.

At the of opening file userform shown, but file unable to open.

Please help...

Regards,


Zameer Shaikh
 

Attachments

Hi,

I added the entry: Administrator
ComboBox1.Value = "ADMINISTRATOR"

Enter Password...

Alternatively, given that I open the File Password Used
Note: The code has an error in opening Vba
 

Attachments

Speedy said:
Hi,

I added the entry: Administrator
ComboBox1.Value = "ADMINISTRATOR"

Enter Password...

Alternatively, given that I open the File Password Used
Note: The code has an error in opening Vba
Click to expand...
Hello Speedy,

Thank for reply. But how to Open file after select administrator. What is the password. And also give details to how to solve this problem.

Regards,


Zameer
 
You can do following.

1. Check Excel settings for opening macro enabling. If the settings are:
"Enable all macros" then change it to
"Disable all macros with notification"
This setting is in
Excel Options | Trust Center | Trust Center Settings | Macro settings.

2. After this, close excel completely once. And then open this file. The file will open but the userform will not be shown. Instead a notification message will be displayed on the ribbon.
"Macros have been disabled"

Do not enable macros. Just go to Visual Basic Editor and change the code as per your requirement.
 
shrivallabha said:
You can do following.

1. Check Excel settings for opening macro enabling. If the settings are:
"Enable all macros" then change it to
"Disable all macros with notification"
This setting is in
Excel Options | Trust Center | Trust Center Settings | Macro settings.

2. After this, close excel completely once. And then open this file. The file will open but the userform will not be shown. Instead a notification message will be displayed on the ribbon.
"Macros have been disabled"

Do not enable macros. Just go to Visual Basic Editor and change the code as per your requirement.
Click to expand...

Hello shrivallbha sir,

Thanks for your valuable reply. It is really good. My knowledge is increased.


Thanks once again.... Please keep in touch.....

Warm Regards,


Zameer Shaikh
 
You must log in or register to reply here.
Back
Top