Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2008

Tip: Looking for answers? Try searching our database.

Disabling the "Design Mode"

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joe - 21 Jan 2008 04:40 GMT
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
Corey - 21 Jan 2008 04:48 GMT
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...

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
Joe - 21 Jan 2008 05:07 GMT
> Why not use the WorkBook Open code to HIDE the Control ToolBox Tool Bar
>
[quoted text clipped - 21 lines]
>
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.