|
Disabling the "Design Mode"
I have some problem in my excel when the user clicks the "Design
Mode". I have protected the Workbook, Worksheet and the VBA Code as well. So, although the user cannot enter the VBA Code, when he selects that button, some of the codes are not working. I have some code on "Workbook Open()" and I think this is the problem area. How can I disable the user from clicking the "Design Mode". Many thanks... Joe |
Disabling the "Design Mode"
Why not use the WorkBook Open code to HIDE the Control ToolBox Tool Bar
Private Sub Workbook_Open() Application.CommandBars("Control Toolbox").Visible = False End Sub This way they cannot click on what is NOT there in the first place. Corey... "Joe" wrote in message ... I have some problem in my excel when the user clicks the "Design Mode". I have protected the Workbook, Worksheet and the VBA Code as well. So, although the user cannot enter the VBA Code, when he selects that button, some of the codes are not working. I have some code on "Workbook Open()" and I think this is the problem area. How can I disable the user from clicking the "Design Mode". Many thanks... Joe |
Disabling the "Design Mode"
On Jan 21, 9:48*am, "Corey" wrote:
Why not use the WorkBook Open code to HIDE the Control ToolBox Tool Bar Private Sub Workbook_Open() Application.CommandBars("Control Toolbox").Visible = False End Sub This way they cannot click on what is NOT there in the first place. Corey... "Joe" wrote in message ... I have some problem in my excel when the user clicks the "Design Mode". I have protected the Workbook, Worksheet and the VBA Code as well. So, although the user cannot enter the VBA Code, when he selects that button, some of the codes are not working. I have some code on "Workbook Open()" and I think this is the problem area. How can I disable the user from clicking the "Design Mode". Many thanks... Joe Thanks Corey. That works for a general user. But still the user can turn on the visibility.. can we prevent that somehow ?? Thanks.. Joe |
| All times are GMT +1. The time now is 11:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com