Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving a spreadsheet with form controls | Excel Worksheet Functions | |||
How to erase pasted controls from an Excel spreadsheet | Excel Discussion (Misc queries) | |||
Controls on Spreadsheet | Excel Worksheet Functions | |||
HTML controls in spreadsheet | New Users to Excel | |||
using visual basic controls in a excel web page saved spreadsheet | Excel Programming |