View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CAPTGNVR CAPTGNVR is offline
external usenet poster
 
Posts: 115
Default 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