urgent help required with a menu bar
Posted by Anna Daly on January 31, 2001 9:36 AM
Hi All,
In a spreadsheet that I have developed I have a macro that deletes all of the menu bars and replaces it with a custom one that I have designed. This works okay, but it is putting the minimise, maximise and close buttons on the bar as well (the ones that appear on all application windows in the top right hand corner). It didn't use to do this but I don't know what has changed. The window is maximised in the macro so therefore these buttons should not appear on the menu bar. Any ideas. I must solve it or the user might exit the spreadsheet with the close button and not the button which I intend them to use. The correct macros will therefore not be initiated and the user will lose all of the work that they have done.
Please, please help!
regards,
Anna
Posted by Gregc on January 31, 2001 11:29 AM
response: Use the on beforeclose event to save the workbook, therefore it is saved everytime it is closed. If you don't want it saved put a message box and an if statement to give the user the option.
Hope that helps.
