View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Shetty Shetty is offline
external usenet poster
 
Posts: 78
Default How to disable hide/unhise command by user?

Thnks for your suggession.
But, I need to do other operations by sheetchange event which
is not working with the protect and "UserInterfaceOnly"=true.
I intend to hide some rows with workbook open event and disable
users to insert/unhide any rows/columns. If user inserts/delets
any row/column, my entire programm gets disturbed and gives
unexpected and wrong results.

Thanks again.
Regards,
Shetty


"Loomah" wrote in message ...
Hi
Could you not protect the worksheet and set the "UserInterfaceOnly" to true?
If not you may find this link useful
http://www.tek-tips.com/faqs.cfm?spid=707&sfid=4841

;-)


Shetty wrote in message
m...
I need to disable hide and unhide commands from the context
menu as well as from main menu for the users of one work book.
With this they should not be able to unhide rows or columns
which I have made hidden by a macro.
How to acheive it?
But at the same time, I want to use these commands programatically
from a macro befor save. Also this commands should be available
to user when they activate any other workbook.
Is it possible?
Regards,
Shetty