Disable controls on spreadsheet
 

How to disable menu control and shortcut keys , I hv a requirement o
excel template which will allow user to edit in particular cells an
after entering data user can only take the printout of that page , h
cannot save,save as , copy ,cut ,paste the sheet .
Is it prossible through macro

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

Disable controls on spreadsheet
 

Here is a code example that disables the Paste control on the Cell
(worksheet right-click) menu

commandbars("Cell").FindControl(id:=22).Enabled=Fa lse


This page gives you a list of all of the control IDs

http://support.microsoft.com/default...b;en-us;159466
XL97: List of ID Numbers for Built-In Command Bar Controls

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"manishc" wrote in message
...

How to disable menu control and shortcut keys , I hv a requirement of
excel template which will allow user to edit in particular cells and
after entering data user can only take the printout of that page , he
cannot save,save as , copy ,cut ,paste the sheet .
Is it prossible through macros


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/