| || |
Join Date: Aug 2011
Re: How to Turn on and off Design mode in Microsoft Excel 2007
First remove workbook protection and sheet protection. That you can use the menu bar, menu "Tools-protection" solve (if it is visible). If the menu bar is not visible, please change via Alt + F11 in the VBA Editor (press ENTER to confirm each) there in the direct area (Ctrl + G) and then enter the following commands:
- Application.Commandbars.Activemenubar.enabled = true
- Application.Commandbars.Activemenubar.visible = true
Changer then back to EXCEL. via View > Toolbars > Customize or right click in the menu bar and choose Customize. On the toolbar Control Toolbox one. There you can activate the design mode, with which you can click on the icon (right-click), without the stored hyperlinks or VBA code to run. Now you can also change the icons, or rename the VBA-/Makro-Code view and modify. From the Panel go on Tools-Options > View sheet tabs one to be able to switch to other worksheets. Possibly the other sheets are hidden, you can it via the Format - Sheet" unhide, or by using VBA you the property Visible" of the leaves to "-1 - xlSheetVisible.