Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable Open option in Excel Report from VB
Hi, How to disable open option when I right click on the excel desktop. By using the following code, I have successfully achieved the disabling of open option from Menu bar and Toolbar. Now I need to disable the same in the Excel desktop’s right Click. Set mFileMenu = CommandBars.FindControl(ID:=30002) ' File Menu If mFileMenu Is Nothing Then Exit Sub For Each mOpenMenu In mFileMenu.Controls If mOpenMenu.ID = 23 Then mOpenMenu.Enabled = False Next mOpenMenu Set mOpenMenu = Nothing Set mFileMenu = Nothing Set mOpenMenuToolBar = CommandBars.FindControl(ID:=23) ' Tool Bar If mOpenMenuToolBar Is Nothing Then Exit Sub mOpenMenuToolBar.Enabled = False Set mOpenMenuToolBar = Nothing We cannot lock the excel file completely, as we need some options like Print, Save As etc. Thanks in advance ourspt -- oursmp ------------------------------------------------------------------------ oursmp's Profile: http://www.excelforum.com/member.php...o&userid=22443 View this thread: http://www.excelforum.com/showthread...hreadid=478191 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save-As Option Disable | Excel Worksheet Functions | |||
how can i enable or disable the paste option in excel 2000 | Excel Worksheet Functions | |||
How can I globally disable the Hypertext link option in Excel? | Setting up and Configuration of Excel | |||
Disable "Save As" Option | Excel Discussion (Misc queries) | |||
Disable 'Error Report' using VBA | Excel Programming |