Macro command to turn on File Menu

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zainuddin Zakaria - 01 Jan 2007 14:03 GMT

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

Reply to this Message

Dave Peterson - 01 Jan 2007 14:42 GMT

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

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

> Hi all,
>
[quoted text clipped - 8 lines]
>
> Zainuddin Z

Signature

Dave Peterson

Reply to this Message

Zainuddin Zakaria - 01 Jan 2007 17:46 GMT

Dear Dave Peterson,

Thank you so much.

It works perfectly the way I want it.

Happy New Year, Dave.

Warmest regards,

Zainuddin Z

> Hi all,
>
[quoted text clipped - 8 lines]
>
> Zainuddin Z

Reply to this Message

Zainuddin Zakaria - 01 Jan 2007 18:16 GMT

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

> Sub testme()

> Application.Dialogs(xlDialogSaveAs).Show

> End Sub

> Hi all,
>
[quoted text clipped - 8 lines]
>
> Zainuddin Z

Reply to this Message

Zainuddin Zakaria - 01 Jan 2007 18:18 GMT

Thanks Dave...

> Hi again,
>
[quoted text clipped - 31 lines]
>>
>> Zainuddin Z

Reply to this Message

Gord Dibben - 01 Jan 2007 18:43 GMT

Either of these should do

ActiveWorkbook.Close

ActiveWindow.Close

Or manaully hit CTRL + w

Gord Dibben MS Excel MVP

>Hi again,
>
[quoted text clipped - 31 lines]
>>
>> Zainuddin Z

Reply to this Message

Dave Peterson - 01 Jan 2007 18:45 GMT

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.

> Hi again,
>
[quoted text clipped - 31 lines]
> >
> > Zainuddin Z

Signature

Dave Peterson

Reply to this Message

Rate this thread: