Macro command to turn on File Menu

[Zainuddin Zakaria]

Hi all,

I have hidden the MENU BAR using a macro command on purpose.

For the user to 'save/save as' his work, I plan to have a button on that
worksheet. The user can open the FILE menu, using that button when pressed.
Can someone suggest a macro command for that button to work the way I plan
it to be if it is possible.

Thank you so much.


Zainuddin Z

 

[Dave Peterson]

One way is to just show the File|Save as dialog.

Option Explicit
Sub testme()
Application.Dialogs(xlDialogSaveAs).Show
End Sub

 

[Zainuddin Zakaria]

Dear Dave Peterson,

Thank you so much.

It works perfectly the way I want it.

Happy New Year, Dave.



Warmest regards,

Zainuddin Z

 

[Zainuddin Zakaria]

Hi again,

This is related to the question below.
Dave Peterson has kindly responded to that and it works.

My next question is how to exit the workbook (file) since there is no MENU
bar again.
Anything similar Macro command to that ?

Thank you.

Zainuddin Z

One way is to just show the File|Save as dialog.

Option Explicit

 

[Zainuddin Zakaria]

Thanks Dave...

Hi again,

This is related to the question below.
Dave Peterson has kindly responded to that and it works.

My next question is how to exit the workbook (file) since there is no MENU
bar again.
Anything similar Macro command to that ?

Thank you.

Zainuddin Z

 

[Gord Dibben]

Either of these should do

ActiveWorkbook.Close

ActiveWindow.Close

Or manaully hit CTRL + w


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Give them another button to close the workbook????

Option Explicit
Sub testme02()
ThisWorkbook.Close
End Sub


But remember to restore all the menus that you disabled. You'll want to be a
nice developer.