can I set a workbook to open in a certain view regardless of how it was when it was saved

[nicody]

Hi,

I am wondering if there is a way to have a worksheet open to a standard view every time it is opened.

I have a multi-page workbook that numerous people will be entering and saving data into. I want to have the workbook open up onto a page with command buttons that will link to other pages. All of the other pages will be hidden until the command button is pressed.

When they are done the workbook will be saved and closed. The next time the workbook is opened I would like it to open onto the page with command buttons and the other page(s) to be hidden once again.

Is this possible?

Deb

this is a link to the original post on the excel general board
https://www.excelforum.com/excel-gen...t=#post5203247

[modytrane]

yes it is possible.
you can write the commands in Workbook_Open

Attachment 643650

[nicody]

yes it is possible.
you can write the commands in Workbook_Open

Attachment 643650

Hi, the attachment doesn't seem to be working. Can you resend please.

Deb

[Pepe Le Mokko]

It is unnecessary to start a new thread in another forum if you think you posted wrong. Just PM a mod ( green usernames in " What's going on or via the Watre Cooler) to move your post.
Thanks.
Your other thread is now closed

[nicody]

closing so I can repost with more information

[nicody]

I have a workbook that has an intro page with several commandclick buttons that lead to other sheets. When a command button is clicked the relevant sheet is unhidden and the intro sheet is hidden so that only on sheet is available in each session.

I would like to have the workbook open to the intro page with all other pages hidden every time the workbook is opened.

I have searched the net and found many variations but nothing has worked for what I am looking for, so I am again turning to the experts.

Hope you all can help.

Deb

[mehmetcik]

You need an Auto Open Macro.

Either a macro in a normal module like:

Please Login or Register  to view this content.

Or a Macro in the This Workbook Macro Module.

Please Login or Register  to view this content.

Either Will run when you open the workbook.

The Macro will be:-

Please Login or Register  to view this content.

Actually you might be better of using this code:=

Please Login or Register  to view this content.

[Pepe Le Mokko]

@nicody
Please stop creating new threads with the same title and that are the continuation of an almost similar thread.
I merged both threads to keep things consistent.
Please read our forum rules about duplicate threads.
Thanks

[nicody]

@ pepe le mokko

I didn't get an answer to the previous post. I tried adding to the post looking for answers but got none. This is why i closed and restarted a new thread.

Thank you for merging the 2 threads, I didn't know how else to get the help.

D

[Pepe Le Mokko]

If you don't get an answer you can always "bump" your thread ( say once every 24hrs) eventually adding information .
You got an answer from mehmetcik. Does it help?
Your question seems clear to me (but I can't help with VBA), I suppose it got unnoticed for some reason

[nicody]

Thanks for the help,

I keeping getting a "compile error:variable not defined" at this line-

For i = 1 To ActiveWorkbook.Sheets.Count

I have entered the code into the thisworkbook area.

When I save, close and reopen the workbook it is not opening to the intro page or hiding the others. I know this has to be something I'm doing wrong I just can't seem to figure it out.

Any ideas?

[nicody]

Thanks I will try the "bump" if I have trouble again.

[nicody]

I cannot get this to work, I have tried removing potentially conflicting code and trying to simplify what I was trying to do but I just can't figure it out.

Anyone else have any ideas?

Thanks