Need your help in Write VBA Coding

[BALA1983]

Dear All,

There are five sheets in my Excel Book. And this is testing file. What I want is, while opening the file, a pop should open and ask for input. "P" , "G" & "CONTROL" is the input command.

Sheet Name in this Testing Excel Book : Sheet1, Sheet2, Sheet3, Sheet4, Sheet5

1. If I give "P", Excel sheet should open with Sheet1, Sheet3, Sheet4, Sheet5

(Sheet 2 need to be auto hided)


2. If I give "G", Excel sheet should open with Sheet1, Sheet2, Sheet4, Sheet5

(Sheet 3 need to be auto hided)

3. If I give "CONTROL" as a password, then all the sheets should appear.

Regards
Balamurugan

[Arkadi]

something like this?

[CK76]

Slightly different approach.

In regular module.

Please Login or Register  to view this content.

In Workbook module.

Please Login or Register  to view this content.

[BALA1983]

Thanks for your great support. One additional option is required. Once if I opened with any one of "P" & "G", then I should not be allowed to see the VBA coding screen as well as I should not be allowed to hide or unhide any of my available sheets.

Only if opened with "CONTROL" then I can see the VBA coding as well as I do hide or unhide sheets.

And also when user open the Sheet with "P" & "G", then he or she should not be allowed to save with same file. Even if he tries to save the file system should prompt him to save as the file.

Only if opened with "CONTROL" then only user should be allowed to do the all the changes.

[BALA1983]

Thanks for your great support. One additional option is required. Once if I opened with any one of "P" & "G", then I should not be allowed to see the VBA coding screen as well as I should not be allowed to hide or unhide any of my available sheets.

Only if opened with "CONTROL" then I can see the VBA coding as well as I do hide or unhide sheets.

And also when user open the Sheet with "P" & "G", then he or she should not be allowed to save with same file. Even if he tries to save the file, system should prompt him to save as the file.

Only if opened with "CONTROL" then only user should be allowed to do the all the changes.