Main menu

Cablek

Board Regular
Joined
Nov 22, 2017
Messages
51
I have an excel template that I would like to open with a main menu... each menu pointing to a sheet (10 in total) 3 of which are password protected.
Sales
Costing sheet (password protected)
Costing work sheet (password protected)
Bom
Cut sheet
Drawings
Production
Qc
Shipping
Employees (password protected)

Is there a vba code to do this?
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
I looked at this several days ago.
To start with what is the sheet name of your Template and what does this mean:

I would like to open with a main menu..
What is a "main menu"?
 
Upvote 0
the sheet names are listed above... I guess the "main menu" would also be know as a dashboard... a sheet that opens automatically when the file is opened then displays the sheets available OR even better a login screen them displays a list that that user has access to.

does this make any sense?

SHEETS:
Sales

Costing sheet (password protected)
Costing work sheet (password protected)
Bom
Cut sheet
Drawings
Production
Qc
Shipping
Employees (password protected)
 
Last edited:
Upvote 0
I asked this:
To start with what is the sheet name of your Template.

You never gave the name.


So are you saying you have a sheet named "Dashboard"

And in column "A" you want a list of all your sheet names entered?

 
Upvote 0
sorry I misread your reply...

Presently I don't have a template sheet but can easily create one called "dashboard"
on that sheet I'd like to have
1) a log in screen with "user name" and Password then it would display the sheets available to that user name
or
2) a list of all the sheets in the spreadsheet some of which are already password protected.

Naturally when you open the file it needs to open on this "dashboard" sheet

Thanks for your patience and help.
 
Upvote 0

Forum statistics

Threads
1,223,889
Messages
6,175,223
Members
452,620
Latest member
dsubash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top