Excel to open specific worksheet

[hkbhansali]

I have a workbook with 8 worksheet, i want code to open excel with "Sheet8",
I have a vb code for workbookopen with password like under

Please Login or Register  to view this content.

Please help.

[Pepe Le Mokko]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

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



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[hkbhansali]

i have posted tag.

[HaHoBe]

Hi, hkbhansali,

obviously not in the OP of this thread so you would still have to fulfill in order to allow us to help you.

Ciao,
Holger

[hkbhansali]

Hi, Holger
as per your Instruction i have post tag.i think now its as per forum rules.
sorry for that,because this is my first thread with VB code.

Thanks for proper Guidance.

[HaHoBe]

Hi, hkbhansali,

try

Please Login or Register  to view this content.

If the code is to work only for access to Sheet8 and not the workbook you should use the Activate-event for triggering the procedure. Please be informed that holding the Shift-key when opening the workbook will deactivate the event.

Ciao,
Holger

[hkbhansali]

HI, Holger
thanks for code, i have try it but when i open my workbook its open with last saved sheet, when i enter password its go to sheet8.

[HaHoBe]

Hi, hkbhansali,

thatīs the normal way VBA handles the code. You would need to tell us what else should be done as VBA will only execute what is laidf down in tehe code - if we donīt code proper no "correct" execution.

Ciao,
Holger