Protect Multiple Sheets

[Simply_Me]

Hi!

I saw this code in picture analytic site. It is working fine but there two things I noticed with it:
1. The Password is visible when entered in the textbox
2. There's no way to control what the users can and cannot do with the worksheet such allowing them to:
a. Format cells
b. Format columns
c. Format rows.

Is there anyway those mentioned above can be achieved?

[6StringJazzer]

We can't answer questions about code without seeing the code. Either attach your file (best), or paste code into a post.

If you paste code please use CODE tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[sintek]

Hi Simply_Me

To answer your question.....Yes anything can be achieved here.....

1. The Password is visible when entered in the textbox

In the properties of the textbox, enter * in the passwordchar

2. There's no way to control what the users can and cannot do with the worksheet such allowing them to:
a. Format cells
b. Format columns
c. Format rows.

I've suggested this code of lenze's a few times today. It allows you to set ranges so that the user cannot edit, format etc

Please Login or Register  to view this content.

[Simply_Me]

We can't answer questions about code without seeing the code. Either attach your file (best), or paste code into a post.

Sorry I forgot to post the code. Here it is

Please Login or Register  to view this content.

[Simply_Me]

sintek, I'm sorry, I'm referring to the textbox of an InputBox()

[Simply_Me]

I want to see this dialog before user can type the password to protect the sheets excel.GIF

[sintek]

Use this code to bring up Protect Sheet dialogue box

Please Login or Register  to view this content.