Macro command to turn on File Menu

  • Thread starter Thread starter Zainuddin Zakaria
  • Start date Start date
Z

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
 
One way is to just show the File|Save as dialog.

Option Explicit
Sub testme()
Application.Dialogs(xlDialogSaveAs).Show
End Sub
 
Dear Dave Peterson,

Thank you so much.

It works perfectly the way I want it.

Happy New Year, Dave.



Warmest regards,

Zainuddin Z
 
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
Click to expand...
 
Thanks Dave...


Zainuddin Zakaria said:
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
Click to expand...
 
Either of these should do

ActiveWorkbook.Close

ActiveWindow.Close

Or manaully hit CTRL + w


Gord Dibben MS Excel MVP
 
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.
 
Back
Top