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
HOW TO FIND last cell from activecell? 5
Macro to Combine Data from Multiple Sheets with Cell References 4
Assigned Macro to button 5
How to enable to excel options from addin using VBA/Macro coding 0
Problem in adding macro to ribbon through Add-in 7
How to record a macro within a macro 9
Macro to go back to last used sheet 1

Top