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

C

CAPTGNVR

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
 
M

Mike Fogleman

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
 
C

CAPTGNVR

Mike said:
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
Click to expand...
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW TO REMOVE 'SHEET TABS' FROM OPTIONS MENU IN VB 3
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
HOW TO FIND last cell from activecell? 5
Removing {PAGE/*MERGEFORMAT} from my microsoft document 5
how to get the resultsheet from the markslips 0
WHY EDIT-FILL-"SERIES" OPTION cannot be seen in one particular sh 3
Macro to Combine Data from Multiple Sheets with Cell References 4
Second run of macro hangs on .show of application.filedialog object! 3

Top