EXCEL MarcoVBA Navigation Menu

[jamzsaludares]

Hi there pro coders,

First, kindly refer to the attached image and lets name it "Navigation menu Bar".
All I want to know is how to do this. I took it from a macro enable excel file.
When I open the said file, a log-in form will pop-up. But lets jud disregard that.

All I want to learn from you is that, When I open a specific excel file, the
"Navigation Menu Bar" Will pop-up and then if I click any of the button, it will
proceed to the assigned worksheet.

I also want to learn how to add button inside the excel file where in if I click, it
will return to "Navigation Menu Bar"

Thank You and More Power

[xladept]

Hi Jamz,

We need to see the code - can you post a sample workbook? (Go to Advanced and click on the paper clip)

[jamzsaludares]

Hi there,

sorry for the delay.
Here is the situation.

1. I have file name lets say "00 FS.xlsm"
2. Inside of "00 FS.xlsm" is a Form "NavigationMenu" refering to above image that I attached.

I was after the "NavigationMenu" to pop-up upon opening the workbook "00 FS.xlsm"

Here is what i did.

Please Login or Register  to view this content.

I pasted it in Sheet1
but nothing happens

[HaHoBe]

Hi, jamzsaludares,

please wrap the procedure with code-tags as requested in Forum Rule #3.

Code has to go into ThisWorkbook in order for the event to get triggered.

Ciao,
Holger

[jamzsaludares]

Hi, jamzsaludares,

please wrap the procedure with code-tags as requested in Forum Rule #3.

Code has to go into ThisWorkbook in order for the event to get triggered.

Ciao,
Holger

Hi there, Its aready functional. Thank You.
Can I ask again another question?

1. My "NavigationMenu" FORM is inside the "00 FS.xlsm"
2. I Copied the "NavigationMenu" inside the "01 Sales.xlsm" so that I can recall it later (If im not wrong)
3. Inside the "NavigationMenu" are buttons:

(a.) FinancialStatement workbooks.open ("D:\Documents\00 FS.xlsm")
(b) Sales workbooks.open("D:\Documents\01 Sales.xlsm")

Not here's what happen.
1. Click Button to open "01 Sales.xlsm" - successful
2. I Open the NavigationMenu - Click 00 FS.xlsm - successful BUT it reopen the file.

This some kind of an IF function.
1. IF "00 FS.xlsm" is not yet open = Open the File
2. IF "00 FS.xlsm" is already open = Just take me to "00 FS.xlsm" , do not re-open

[HaHoBe]

Hi, jamzsaludares,

loop through the workbooks in the instance of Excel and set the object to the workbook else activate the workbook.

I assumed the workbook to be stored in the same folder as the workbook that is starting the routine:

Please Login or Register  to view this content.

Ciao,
Holger

[jamzsaludares]

Hi, jamzsaludares,

loop through the workbooks in the instance of Excel and set the object to the workbook else activate the workbook.

I assumed the workbook to be stored in the same folder as the workbook that is starting the routine:

Please Login or Register  to view this content.

Ciao,
Holger

Hey There,

Working like charm. Thank a lot, I really appreciate it.
One last thing and im done. Here is what I did.

I did a tweak on my excel. To make excel not visible and only
the NavigationMenu form shall appear. It works fine, but I can't
get rid of this one. See attached image.


Whenever I open excel "00 FS.xlsm" this one will pop-up. when I
click continue, It will now proceed to NavigationMenu form.


Private Sub CommandButton1_Click()
Application.Visible = True
Me.Hide
End Sub


Thank You

[jamzsaludares]

Up for this one last question of mine. :D
Thank You for everyone who helped me a lot.
Credits to all of you. This project gave me
an incentive to my work.

I will make a tutorial on this one, and hoping
that I can also help someone who need this,
of course your name will be included as my
mentors.

[HaHoBe]

Hi, jamzsaludares,

you certainly may believe the last question to be part of the original question but I´m afraid that it has nothing to do with that question.

Maybe try

Please Login or Register  to view this content.

Ciao,
Holger