Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel version '97 not allowing user to hit the "X"

Status
Not open for further replies.

eryctus

IS-IT--Management
Oct 14, 2002
17
0
0
US
I have one installation of Office '97 PRO that somehow disallows the user to hit the "X" on the Menu bar to exit the program. Also, if you try to close the spreadsheet, File/Close I get VB Runtime ERROR 91.
Any ideas?
Thanks in advance.
E
 
Do you mean the X that closes a WORKBOOK or the X that closes EXCEL

Both can be disabled in a coupla ways
For workbooks, simply protection of the workbook along with ticking the WINDOWS tickbox in the options will make the X disappear completely. there is also an API call that will disable the X in the window Rgds
~Geoff~
 
Sorry it's the x that closes the program
E
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top