USING MACRO REMOVED -OPTIONS- FROM TOOLS. HOW TO GET IT BACK?
 

DEAR ALL

Since I had many sheets and the users were frequently going thro, i
got the sheet tabs removed from vb. Still they used to use options-
and activate the sheet tabs. Then i used macro to remove the tools-
option. How to get the tools-option back. There is no reset for this
option and eventually i have to reload excel97. Yes we still use
excel97. Pls adv

USING MACRO REMOVED -OPTIONS- FROM TOOLS. HOW TO GET IT BACK?
 

My first guess would be to search your hard drive for *.xlb and if you find
one like Excel.xlb or Excel7.xlb, then delete it and re-start Excel. Excel
will then create a new one using the installation default options.

Mike F
"CAPTGNVR" wrote in message
ups.com...
DEAR ALL

Since I had many sheets and the users were frequently going thro, i
got the sheet tabs removed from vb. Still they used to use options-
and activate the sheet tabs. Then i used macro to remove the tools-
option. How to get the tools-option back. There is no reset for this
option and eventually i have to reload excel97. Yes we still use
excel97. Pls adv

USING MACRO REMOVED -OPTIONS- FROM TOOLS. HOW TO GET IT BACK?
 

Mike Fogleman wrote:
My first guess would be to search your hard drive for *.xlb and if you find
one like Excel.xlb or Excel7.xlb, then delete it and re-start Excel. Excel
will then create a new one using the installation default options.

Mike F
"CAPTGNVR" wrote in message
ups.com...
DEAR ALL

Since I had many sheets and the users were frequently going thro, i
got the sheet tabs removed from vb. Still they used to use options-
and activate the sheet tabs. Then i used macro to remove the tools-
option. How to get the tools-option back. There is no reset for this
option and eventually i have to reload excel97. Yes we still use
excel97. Pls adv

THANK YOU MIKE. I searched and could not find the two xlb files u hv
mentioned. What is the next step if i dont find those xlb files?