Excel VBA app Basics

[qlark]

I just wrote a VBA game app in Excel 2k just for some fun and two things I cannot seem to do; (can't market this sorry its already copyright ... just a bit of fun to help learn more about the capabilities of VBA in office).

1) get rid of the menu bar (every time I go into custom and turn off the menu ... as soon as I hit apply it comes right back ... is there a command in VBA that will turn this off?

2) the app has a hidden work sheet that keeps random data for calculations for this simple game ... so when the user goes to exit the app its asking to save the changes (even though the workbook is read only) ... is there a way to tell Excel to bypass this? I can sort of think of a kludge as in; save-as file, delete file, ... but hoping there would be a better way ... such as exit no save?

 

[Loomah]

Hi
1) For the Menu bar yoou need to set the enabled property to false. Have a look at this faq707-4841 for some basic pointer for enableing/disabling commandbars etc.

2) In the before close event of the workbook "con" Excel into thinking the file is already saved by using
thisworkbook.saved = true

Have Fun!

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​