|Subject:||Re: Macro Command to Exit|
|Posted by:||Zainuddin Zakaria (sal…@tm.net.my)|
|Date:||Wed, 3 Jan 2007|
Dearest Bob Phillips and Chip Pearson,
Thank you so much. The code both of you suggested work perfectly like I
I really appreciate it.
"Zainuddin Zakaria" <sal…@tm.net.my> wrote in message
> Hi again,
> This is related to the question below.
> Dave Peterson has kindly responded to that and it works.
> Thanks, Dave.
> My next question is how to exit the workbook (file) since there is no MENU
> bar again. I would like to have Macro command to do that (Exit) with a
> warning message to save first.
> Please help ... Thank you.
> Zainuddin Z
> "Dave Peterson" <peters…@verizonXSPAM.net> wrote in message
>> One way is to just show the File|Save as dialog.
>> Option Explicit
>> Sub testme()
>> End Sub
> "Zainuddin Zakaria" <sal…@tm.net.my> wrote in message
>> 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
Macro Command to Exit posted by Zainuddin Zakaria on Tue, 2 Jan 2007