Disable controls on spreadsheet

  • Thread starter Thread starter manishc
  • Start date Start date
M

manishc

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
 
Here is a code example that disables the Paste control on the Cell
(worksheet right-click) menu

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


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

http://support.microsoft.com/default.aspx?scid=kb;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)
 
Back
Top