| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tools options view window options | Excel Discussion (Misc queries) | |||
| Smart Tags - Removed - How can I get them back???? | Excel Worksheet Functions | |||
| Macro to stop Tools, Options, Edit | Excel Discussion (Misc queries) | |||
| Working with options from within Tools Options clears the Clipboar | Excel Programming | |||
| How to diasble the 'Tools - Options - View - Comments' options? | Excel Programming | |||
Linear Mode
