Selecting Opening Sheet

[Barry1903]

Hello all.

I have designed a workbook with a front dashboard and I would like the workbook to open on this sheet all of the time,

How can I do this?

[Richard Buttrey]

Hi,

Use the Workbook_Open event in the VBE

Please Login or Register  to view this content.

HTH

[Cheeky Charlie]

If you are allowing users to edit and save your workbook, you would probably need to apply a workbook_open macro to activate the sheet - but this would reqire users to enable macros, which they won't without significant persuasion.

If not, you can just save the workbook with that page at the front.

[Barry1903]

I already have full screen application code for Private Sub Workbook_Open()

Can I add another one

[Cheeky Charlie]

just insert the line:

Please Login or Register  to view this content.

in the existing macro.
You can not create two.

CC